1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

  2. 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


  3. 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

Discussion in 'Discuss Data Visualizations and Charting' started by Aman80, Nov 30, 2018.

  1. Aman80

    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.


    Attached Files:

  2. GraH - Guido

    GraH - Guido Well-Known Member

    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...

    Attached Files:

    Last edited: Nov 30, 2018
  3. Aman80

    Aman80 New Member

    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.
  4. GraH - Guido

    GraH - Guido Well-Known Member

    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

    Attached Files:

Share This Page