ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Line Graph excluding 0 values (https://www.excelbanter.com/excel-discussion-misc-queries/249828-line-graph-excluding-0-values.html)

Sasikiran

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.


All times are GMT +1. The time now is 11:14 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com