Scale axis on 3d column chart in Office 2010

[Pauljj]

Slightly confused, I am using a 3D cluster chart in office 2010 and the horizontal major gridlines are showing. One column is the hight of 5.58 but on the chart shows a fraction under 6 whereas the column witht the hight on 5.98 is over 6

I am new to 2010 so is there something obvious I am missing please ?

 

[Steve=True]

Hi Pauljj,

3D charts are usually very confusing to viewers and can be misleading. Typically they are not recommended by Dashboard/Graphic designer.

Check out Jon's disertation on the perils of 3D The Perils of Being in 3D | Peltier Tech Blog | Excel Charts

Now that being said, I have seen an Excel 3D chart that had us reaching our goal of 100% and the bar didn't reach the gridline.

I think it is an escewness error that can happen when using Excel for 3 D charts.

I would recommend using a 2 D chart.

Hope this helps!

Steve=True