Ignoring blank cells in chart

[FM1]

Is there a way to ignore blank cells within a range for a bar chart? The values in the range are based on an IF statement where by if the statement is true, then it returns a value, and if its false, then its blank.

I have done a thorough search on google, but I havent find a solution that actually works.

Any help is appreciated.

[Andy Pope]

In a column/bar chart the only way to skip categories is to hide the row.

If the categories are all at the end then Named ranges can be used to restrict data charted

[FM1]

In a column/bar chart the only way to skip categories is to hide the row.

If the categories are all at the end then Named ranges can be used to restrict data charted

Because the table is dynamic, its not possible hide a specific number of rows.

The categories are actually right at the front and all the blank cells are at the end.

[Andy Pope]

So it meets the criteria for using named ranges. There are many many posts on the forum.

[FM1]

So it meets the criteria for using named ranges. There are many many posts on the forum.

Great. Ill have a look through.

Ill bump this thread if I have no luck.

Thanks.