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

Trouble replicating microchart in dashboard tutorial post..

Hello Forum,
I'm practicing with the skills required in a Chandoo KPI dashboard post on microcharts. When I try to replicate the microchart that is in the example file, I cannot get the "Average" data series to extend all way down to the last data point. This tutorial is found at this address: http://chandoo.org/wp/2008/09/10/kpi-dashboards-graphs-excel/

In the example microchart, the black line for the "Average" series extends the length of the graph across all ten data points. When I try it, it stops right before the tenth data point. I have attached the file where I'm struggling with this. Can anyone tell me how I need to change the axes to so that the average line extends the length of the chart like the example graph? I can't find the secondary axis on the example microchart to figure this out.

Your help is greatly appreciated. Thank you in advance!

greykitten
 

Attachments

On the secondary vertical axis, change the min/max to be fixed at 1 and 10, not 0 and 10.

In the example chart, you can select the chart, then go to Chart Tools - Layout, Axes, Axes - Secondary Vertical Axis to display it.
 
Back
Top