GRAPH PROBLEM

neills

Board Regular
Joined
May 6, 2002
Messages
104
Hi all

Can anyone tell me how to set up a graph so that it only uses cells that contain values.

My chart is for a daily usage runs from Monday to Sunday and is a line graph. but my problem comes with empty day makes the graph dive to zero and then return back up on the next day.
some weeks can use only two days and some can have upto seven days.
Is there a nice and easy way to redo my chart

Thanks Neill
 

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
filter the blanks out in the source data - default is to plot visible cells only.
 

neills

Board Regular
Joined
May 6, 2002
Messages
104
Hi Paddy

Funny I was just looking at a joke site called paddysworld.co.uk.
Anyway I don't quite understand what you mean, do you mean just take the cells out of the data range. If so that isn't quite what Im after, I want a universal graph that can be used for all if possible.

Neill
 

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
"do you mean just take the cells out of the data "

No, i mean apply a filter.

Describe the data you are plotting, how it's set up etc
 

Iridium

Well-known Member
Joined
Jul 15, 2002
Messages
2,831
MartinK said:
in case you need to interrupt the line on the NA value, you'll need VBA.

or go to tools>options-chart tab and select "plot empty cells as:" either not plotted or interpolated
 

MartinK

Active Member
Joined
Oct 30, 2003
Messages
384
Whoops, forgot about that one, sorry. :oops:

But this does not work for error values, just for blanks, right?
Martin
 

Iridium

Well-known Member
Joined
Jul 15, 2002
Messages
2,831
MartinK said:
Whoops, forgot about that one, sorry. :oops:

But this does not work for error values, just for blanks, right?
Martin

If the cell value for the graph formulaically returns NA then it'll interpolate else AFAIK you're right :)
 
Learn Excel from Bill Jelen

Understanding data is crucial, and the easiest place to start is with Microsoft Excel.

Forum statistics

Threads
1,151,563
Messages
5,765,123
Members
425,262
Latest member
sabry

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top