Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Don't include category X labels if row empty
Hi
I have a table that looks a bit like this: ABC XYZ General Review 2.8 0.5 2 Month Review 3 Month Review 2.6 ERIT Review 3.5 Physio Review 16 4 Pain Review WAD Review Low Back Review 4 2 Each month the number will change for each row, some months they will be entirely blank, other months they will contain numbers. I only want the chart to show the review type on the Category X axis if there is data in either column ABC or XYZ. In other words, this month should not show 2 Month Review, Pain Review or WAD Review. I've been reading all the posts about dynamic charts - but that doesn't suit because my zero values are dotted throughout the table - not just at the end. Changing the formula to display #N/A doesn't work either - the label is still there on the x-axis. Does anyone have any other ideas? Thanks for your help. Sally |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Don't include category X labels if row empty
Select the range and apply an AutoFilter (Date menu Filter AutoFilter).
Click the down arrow next to ABC and select Nonblanks. The hidden rows with blanks will not appear in the chart, because by default, hidden cells are not plotted. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Sally Poyzer" wrote in message ... Hi I have a table that looks a bit like this: ABC XYZ General Review 2.8 0.5 2 Month Review 3 Month Review 2.6 ERIT Review 3.5 Physio Review 16 4 Pain Review WAD Review Low Back Review 4 2 Each month the number will change for each row, some months they will be entirely blank, other months they will contain numbers. I only want the chart to show the review type on the Category X axis if there is data in either column ABC or XYZ. In other words, this month should not show 2 Month Review, Pain Review or WAD Review. I've been reading all the posts about dynamic charts - but that doesn't suit because my zero values are dotted throughout the table - not just at the end. Changing the formula to display #N/A doesn't work either - the label is still there on the x-axis. Does anyone have any other ideas? Thanks for your help. Sally |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Worksheet Column Labels ... Alphabet or Numeric ? | Excel Discussion (Misc queries) | |||
Force bar chart x-axis labels to two lines? | Charts and Charting in Excel | |||
alignment of y axis category labels | Charts and Charting in Excel | |||
How do I move the Category Axis labels outside of the Plot Area? | Charts and Charting in Excel | |||
Empty Cells, Spaces, Cond Format? | Excel Discussion (Misc queries) |