how do I add error bars to a 3D chart in excel?

E

elahe

The help states you can only add error bars to data series in 2D area. Is
there a way to add them to a 3D chart?
 
A

Andy Pope

Hi,

I would not have thought so. Obviously as it is not a built-in option
the only way would be a work around perhaps using dummy series.
Unfortunately you can create 3d combination charts.
Stick with the 2d view.

Cheers
Andy
 
J

Jon Peltier

I checked, and error bars are not offered for 3D charts. As Andy suggests, keep away
from the 3D chart types. That third dimension usually has nothing to do with the
dimensionality of the data, and everything to do with distorting the information in
the chart.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

3D stacked bar and line chart on same graph 2
Convert Error Bars to Series and Colour 1
Filtered view of Visio Chart 0
Dynamic Chart Title With 3D Stacked Column Chart 2
move data labels on a 3d bar 4
Move x axis to the top of a 3D horizontal bar chart 1
3D Stacked Column Chart 2
sideways stacked bar charts with line series on the same axis 0

Top