Excel Graph Problem - HotUKDeals
We use cookie files to improve site functionality and personalisation. By continuing to use HUKD, you accept our cookie and privacy policy.
Get the HUKD app free at Google Play

Search Error

An error occurred when searching, please try again!

Login / Sign UpSubmit

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 …
fairysel Avatar
banned6y, 11m agoPosted 6 years, 11 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.

Thanks in advance!
fairysel Avatar
banned6y, 11m agoPosted 6 years, 11 months ago
Options

All Comments

(15) Jump to unreadPost a comment
Comments/page:
#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)))

Post a Comment

You don't need an account to leave a comment. Just enter your email address. We'll keep it private.

...OR log in with your social account

...OR comment using your social account

Looking for Twitter login?
Thanks for your comment! Keep it up!
We just need to have a quick look and it will be live soon.
The community is happy to hear your opinion! Keep contributing!