• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Mutiple KPI line graph

Aman80

New Member
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
 

Attachments

  • abc copy.xlsx
    8.7 KB · Views: 4
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...
 

Attachments

  • Copy of abc copy.xlsx
    16 KB · Views: 8
Last edited:
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.
 
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
upload_2018-12-1_11-19-26.png
 

Attachments

  • Copy of abc copy.xlsx
    21.5 KB · Views: 10
Back
Top