Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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, |
#2
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 _______ "bronxbabe" wrote in message ... 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how can I limit my chart | Charts and Charting in Excel | |||
3D column chart, stacked | Charts and Charting in Excel | |||
Column Chart | Charts and Charting in Excel | |||
Column Chart | Charts and Charting in Excel | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions |