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, |
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 |