Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I want to use an area chart to show values for data series above a certain
minimum Z axis value. Unfortunately, I can't find a way to hide parts of series that have values below this minimum. The chart shows a continuation of the series as though the values were AT the minimum. I've also tried to manually clear cells in the table that have values less than the mimum but that hasn't worked. Any suggestions? |
#2
![]() |
|||
|
|||
![]()
XL's ability to draw 3D charts is very limited. You have hit one of
the limitations. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... I want to use an area chart to show values for data series above a certain minimum Z axis value. Unfortunately, I can't find a way to hide parts of series that have values below this minimum. The chart shows a continuation of the series as though the values were AT the minimum. I've also tried to manually clear cells in the table that have values less than the mimum but that hasn't worked. Any suggestions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sum minimum values in a pivot table | Excel Worksheet Functions | |||
interchangine catergory and values axis | Charts and Charting in Excel | |||
catergory on the X axis; values on the Y axis | Charts and Charting in Excel | |||
Y axis, need varying units | Charts and Charting in Excel | |||
hiding values that havent been used yet | New Users to Excel |