Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Zero values in charts
Would anybody know how I can avoid showing data point gaps on a column chart.
E.g. Red Wine 1000 White Wine 0 Rose Wine 1400 How can I avoid showing White Wine in the chart (without deleting the row)? Any comments would be greatly appreciated Thanks Accounts |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Zero values in charts
put a #N/A in place of all zeros... you may have to you IF..THEN statements
on your worksheet "Accounts" wrote: Would anybody know how I can avoid showing data point gaps on a column chart. E.g. Red Wine 1000 White Wine 0 Rose Wine 1400 How can I avoid showing White Wine in the chart (without deleting the row)? Any comments would be greatly appreciated Thanks Accounts |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Zero values in charts
You could also use an Autofilter, and hide any rows with zero in that
column. By default, hidden cells are not included in charts. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Accounts" wrote in message ... Would anybody know how I can avoid showing data point gaps on a column chart. E.g. Red Wine 1000 White Wine 0 Rose Wine 1400 How can I avoid showing White Wine in the chart (without deleting the row)? Any comments would be greatly appreciated Thanks Accounts |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I keep zero values from plotting in charts? | Charts and Charting in Excel | |||
Charts and sub-values | Charts and Charting in Excel | |||
Zero Values in Charts | Excel Worksheet Functions | |||
Zero Values on Charts | Charts and Charting in Excel | |||
hiding zero values in charts | Charts and Charting in Excel |