3D Column Chart

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

bronxbabe - 30 Mar 2006 05:31 GMT

I have a 3D column chart with numeric values. My Value (Z) axis scale is
1-Minor, 4-Major, 20-Maximum, 0-Minimum. My highest value isn't really 20.
I need it to reflect an infinite value (a break in the bar). How is that
done? Hopefully my question is clear. Thanks in advance,

Reply to this Message

Jon Peltier - 30 Mar 2006 12:52 GMT

If you can use a 2D chart, you will find such effects to be possible:

http://peltiertech.com/Excel/Charts/BrokenYAxis.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______

>I have a 3D column chart with numeric values. My Value (Z) axis scale is
> 1-Minor, 4-Major, 20-Maximum, 0-Minimum. My highest value isn't really
> 20.
> I need it to reflect an infinite value (a break in the bar). How is that
> done? Hopefully my question is clear. Thanks in advance,

Reply to this Message