Line graph showing '0' points
 

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.

Line graph showing '0' points
 

Hi,

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

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

Cheers
Andy

pdberger wrote:
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.