Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart values for blanks show as zero (Excel 2003)
I have a chart for quarterly activity (13 weeks per quarter).
The chart data is a static range which is updated weekly. For weeks which have not occurred yet the fields are blank. However, the chart shows these weeks as having zero and plots them on the chart. How do I avoid this and only have blanks on the chart? Thanks for your assistance, |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart values for blanks show as zero (Excel 2003)
Are the cells blank? They have to be completely empty to register as blanks.
A formula that returns "" is not a blank. You can use NA(), which is skipped in a line or XY chart: =IF(A1=0,NA(),A1) This puts #N/A into the cell, which looks ugly, but the chart no longer thinks you mean zero. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ " wrote in message ... I have a chart for quarterly activity (13 weeks per quarter). The chart data is a static range which is updated weekly. For weeks which have not occurred yet the fields are blank. However, the chart shows these weeks as having zero and plots them on the chart. How do I avoid this and only have blanks on the chart? Thanks for your assistance, |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart values for blanks show as zero (Excel 2003)
Thank you very much for the information. It appears to work perfectly.
Its okay that it looks "ugly" the source data is not being included in the presentation. "Jon Peltier" wrote: Are the cells blank? They have to be completely empty to register as blanks. A formula that returns "" is not a blank. You can use NA(), which is skipped in a line or XY chart: =IF(A1=0,NA(),A1) This puts #N/A into the cell, which looks ugly, but the chart no longer thinks you mean zero. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ " wrote in message ... I have a chart for quarterly activity (13 weeks per quarter). The chart data is a static range which is updated weekly. For weeks which have not occurred yet the fields are blank. However, the chart shows these weeks as having zero and plots them on the chart. How do I avoid this and only have blanks on the chart? Thanks for your assistance, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In bar chart using values-NOT show the value of zero | Charts and Charting in Excel | |||
show only items with values on chart | Charts and Charting in Excel | |||
Excel 2002 : Why VLOOKUP formula does not show blanks or N/A ? | Excel Discussion (Misc queries) | |||
How do I stop line on chart - Pste-specl-values (BLANKS) in VB | Charts and Charting in Excel | |||
How can I get the zero values at the end of a chart not to show? | Charts and Charting in Excel |