Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Line Graph excluding 0 values
Dear,
I have plotted a line graph consisting the data for the entire month. The data range is getting calculated automatically by a formula. 1 Dec - 100 2 Dec - 105 3 Dec - 0 4 Dec - 0 So on... The data for the days starting from 3 Dec is zero and the line graph suddenly goes down to zero... Is there any way that the line graph picks the data excluding the zero values? I mean the line graph should only take the data for 1 Dec and 2 Dec without changing the data range. Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
plotting line graph with 2 x values | Excel Discussion (Misc queries) | |||
Create a line graph of quanitity of values | Charts and Charting in Excel | |||
X axis values on a line graph | Charts and Charting in Excel | |||
Excluding empty/zero values in graph - highlight area in chart | Excel Discussion (Misc queries) | |||
overcoming zero values in line graph | Charts and Charting in Excel |