| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
2003 Excel Chart with zero data
I have a chart that shows the fiscal year. In the months that currently do
not have data it is charting to a zero for the month. How can I get the chart not to show the next month's that have a zero for a value? The catch is that some months maybe zero and the months that do not have a value are currently empty. Below is the formula that I am currently using. =IF(SUM('Global KPI Monitoring chart'!F7:F8)=0,IF(AND('Global KPI Monitoring chart'!F7="", 'Global KPI Monitoring chart'!F8=""),"",0),SUM('Global KPI Monitoring chart'!F7:F8)) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 2003 Excel Radar Chart Data Label Position | Excel Discussion (Misc queries) | |||
| multiple data series in an x-y scatter chart - Excel 2003 | Charts and Charting in Excel | |||
| How do I change the order of the data in a pie chart - excel 2003 | Charts and Charting in Excel | |||
| Column chart not displaying some data points - Excel 2003 | Charts and Charting in Excel | |||
| Stacked Bar Chart - Data Labels:Percentage - Excel 2003 | Charts and Charting in Excel | |||
Threaded Mode
