Excel Graph Question

[graviz]

Here's what I have:

A bar graph where the source data is:C$6:$O$7

The Axis is: YTD, January, February, March, and so on through December.

Currently I only have data through April (C6:G7).

The source data is vlookup(ed) off of another sheet.

Is there a way to have the graph only display the information where I have values. I've tried an if statement (for the axis and the data) and if it's blank or iserror return either a blank "" or return an #N/A via NA(). Neither have worked thus far. Any ideas?

 

[Robert Mika]

This may be solution to your problem:
http://www.ozgrid.com/forum/showthread.php?t=47880&page=1

 

[graviz]

This may be solution to your problem:
http://www.ozgrid.com/forum/showthread.php?t=47880&page=1

Thanks! That worked perfectly.