| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Area chart dives to zero when data series stops
I have a series like so:
Jan 10,11,13,12 Feb 10,12,13,12 Mar 11,11,13,14 Apr 12,13,13,13 May Jun Jul And so on - the rest of the year is blank. When I draw an area chart for the full 12 months the series draws an area up to April, then plummets to zero in May. I want the area to just stop at April. My cells use the formula =IF($A11<=$D$17,G11,NA()) therefore, the NA stops any line charts goinf beyond April, but the area chart is more problematic. Please help!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Series Labels in Area Chart | Charts and Charting in Excel | |||
| Cutting a line in a line chart when data series stops | Charts and Charting in Excel | |||
| Applying data as a line over an area chart | Charts and Charting in Excel | |||
| Adding lines of data to an area chart | Excel Discussion (Misc queries) | |||
| chart data series -- plot a table as a single series | Charts and Charting in Excel | |||
Threaded Mode
