Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 104
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
plotting line graph with 2 x values Jase Excel Discussion (Misc queries) 4 July 14th 09 04:06 PM
Create a line graph of quanitity of values a0xbjzz Charts and Charting in Excel 1 October 3rd 08 08:16 PM
X axis values on a line graph Marlene Charts and Charting in Excel 1 April 23rd 08 10:00 PM
Excluding empty/zero values in graph - highlight area in chart scott Excel Discussion (Misc queries) 2 September 11th 06 04:36 AM
overcoming zero values in line graph marika1981 Charts and Charting in Excel 3 March 11th 05 02:09 AM


All times are GMT +1. The time now is 07:18 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"