Excel Graph Problem - HotUKDeals
Get the HotUKDeals app free at Google Play

#### Search Error

An error occurred when searching, please try again!

# Excel Graph Problem

£0.00 @
Hi, Im wondering if any of the computer experts on here could help me with an excel dilema please? I have an excel table that is auto updated and from this i have created a line graph. Some of … Read More
banned7y, 3m agoPosted 7 years, 3 months ago
Hi,

Im wondering if any of the computer experts on here could help me with an excel dilema please?

I have an excel table that is auto updated and from this i have created a line graph. Some of the fields in the table are 0 as they are for dates that havent yet happened. Because of this the line plummets at theis point where as i just want it to end if the cell=0.

Tags:
banned7y, 3m agoPosted 7 years, 3 months ago
Options

(15)
#1
what version of excel are you on?
#2
dont think there is a function for that, but if anyone can correct me be my guest. I'd like to know too, alternatively have you tried not putting 0's in? as im sure if there is no value it will only show the x,y but not result/s.
1 Like #3
In (2003) tools > options > chart, there is a plot empty cells as not plotted. Try this then come back if no good.
banned#4
Thanks for the help guys. Im in excel 2007. Im trying to make a spreadsheet that auto updates so the details in the tables have forumulats in, ive tried putting IF functions in to return text or a space if theres no data avilable yet. The empty cells not plotted doesnt work am afraid as the cells aren't empty they have formulas in. Looks like im going to have to manually update it :-(

Thanks anyways!!
#5
Can you post an example of what formula is in the cell?
banned#6
=IF('Daily Figures'!T97=0," ",(SUM('Daily Figures'!T97:T126)))
banned#7
It was just =SUM('Daily Figures'!T97:T126)

I put the IF function in to put a space rather than a 0 as i thought that would help but no luck :-(
#8
Try "-" for when it's zero.
#9
Double click on the relevant axis on the graph; go to tab 2 "axis" and change the scale to one which does not encompass the vacant cells.
banned#10
Just tried, it still drops. Stupid Excel!
banned#11
Thanks Chester but still no luck!
#12
fairysel
Thanks Chester but still no luck!

The range of your graph must be wrong if it is picking up fields which are not relevant.
banned#13
The fields are relevant just not yet. Its a table of monthly figures, it covers the rest of 2010 but there is obv no data after march yet
#14
It is still a zero which excel will pick up on.
#15
Change it to

=IF('Daily Figures'!T97=0,NA(),(SUM('Daily Figures'!T97:T126)))