Graph displaying data of empty cells

[jiminchina]

Hello guys,

Having a problem with a graph. Basically, I'm trying to display figure across 12 months. However, for the months that have not happened yet I do not have figures for. Eg. June onwards this year. At the moment the line graph is displaying all of these figures as zero so it makes the line plummet down and continue until December which is pretty unsightly for my boss and visitors to our company. I would like the graph not to display results that do not have anything in them.

How can I do this? Is there a formula I can put in my range so that it does not display empty cells.

I could of course manually change the range each time but considering there is more than one graph and many different users it is not very good.

Best Regards,

James

 

[jeffreybrown]

Hi James,

Take a look at a dynamic chart

 

[snoopyhr]

if you force the formula you use to get the data to result yo #n/a, then you will get the result you want.

Say your data is a result of vlookup, or index match or just simple equal to , if you construct it as :
=if(your formula here=0,na(),your formula)

 

[jiminchina]

-- removed inline image ---

 

[jiminchina]

Okay, the NA() formula was what I was looking for. Thank you!

James

 

[snoopyhr]

Welcome,