Mutiple KPI line graph

[Aman80]

Looking inputs from experts:
Have a quarter over quarter trend for different KPI, but there range varies from very high to very low
Need guidance on plotting this data to draw more insight by showing Q/Q variance or percentage change.
Have attached sample data for reference and getting directions to plot them as excel graph.

Regards
Aman

 

[GraH - Guido]

You can normalize the data by setting a baseline "0" (the value of first period) and then show variance (+/-) towards baseline in %.

Note: % are vary erratic with low numbers (<100) and mask variance when the numbers get too big (like diff 0.0000012% might be a huge difference when looking at absolute numbers).

Consider making different charts for your low (responses) or high numbers (volumes).

EDIT: made something with your data...

 

[Aman80]

Thanks, G for your quick help on this, have tried a couple of options different charts for your low or high numbers (volumes). But the graph appears to be cluttered and does not reflect any insight.

 

[GraH - Guido]

Hi again, you say it is about KPIs, so are there any targets? Currently I only seem some metrics.
You could compare volumes with same period last year or so, use a CAGR method,.. What kind of insight are you after? Statistical?
Charts become cluttered because of to many data series....
Why would you want to plot volumes and responses on the same chart?

% change can be done like this as well