Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Charting / December 2007

Tip: Looking for answers? Try searching our database.

Line graph showing '0' points

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
pdberger - 26 Dec 2007 20:20 GMT
Good afternoon --
I'm creating template workbook into which users will eventually store the
last four year's worth of data, and line graphs will depict that data.  Some
of the users have that much data, but others may only have a year or two to
start off with.  There are a lot of complicated formulas, so most of the
workbook is protected.

Right now, if the user has four years of data, the graphs look fine.  
However, if they have less than that, I've as much as 75% of the graph
sitting at zero.  I'd MUCH rather have that part of the graph be completely
blank, but can't figure out how to do it.

The graph gets its source data from a column of calculated cells.  I've
tried creating 'IF' statements in those cells so that, if there's no data,
they're just blank.  That hasn't worked.  Is there something else I can try?

Thanks in advance.
Andy Pope - 27 Dec 2007 11:07 GMT
Hi,

You need to use NA() instead of "" in your formula.

IF( <your test> , <chart value> , NA() )

Cheers
Andy

> Good afternoon --
> I'm creating template workbook into which users will eventually store the
[quoted text clipped - 13 lines]
>
> Thanks in advance.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.