• 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

  • KPI Dashboard Table Scroll Sort & Brush & Visualize Part 4.xls
    375 KB · Views: 9
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