Excel 2007: Bar Graph to completely ignore zero values?

[JazzSP8]

Hi all

I've been trying to get a bar graph to completely ignore zero values and I just can't work it out.

The graph is dynamic in that I've got it set up so that you can scroll through days by pressing a button to increase / decrease the date.

The problem is that we have a series of catalogues and there daily value plotted against them, unfortunately it's got to the stage where you can't read the Data Table at the bottom of the graph because of the number of catalogues, as not all the catalogues have sales every day I'd like to try and get it so that the graph only displays catalogues that have sales on a given day.

I've tried using IF statements to blank out the cells or NA() them but the still appear in the data table and have a blank instead of a bar.

I realise I might have to create a whole new data series to sort this out but I can't think of a way of doing that dynamically to bring me a list of catalogue names / values.

Can anyone offer any help?

Thanks.

 

[JazzSP8]

Managed to solve this one myself

I forgot that you could hide columns and they'd dissapear from the Graph, it's been a while

So, just created a macro on a sheet change event that would unhide all the columns and then rehide all the columns with a zero value in the data ranges row.

It's a bit choppy but it does it's job

Thanks to everyone who took the time to look at this