hide a series in a chart

hello,

I have a chart with 7 categories (line's data) and 3 series (column's data).
It's like every category in the graph has 3 types of data (actual, budget, forcast for example).
I have a list-box where you can choose the type of series/data that you want to display (i can have actual2012+actual2013+budget2013 or actual2013+forcast2013+budget2013) and the graph changes as chosen.

The problem -
When I want to display only 2 series like actual2013+forcast2013 only, I can't hide the 3rd series and it stays there as it all with 0 values. The 2 first series are not in the middle of the scale and the legend has the the 3rd series colored square with no title of course.
Hiding the entire column doesn't work as hiding a line (then the category is hidden).

how can I fix this for dynamically use?

Not quite sure I understand what you need but, have you tried Conditional Formatting to remove the "0"?

Maybe I wasn't that clear...
There's no "0" in those cell, they are empty. The series chart stays empty and it looks like there are 3 series although you see only 2.
Those 2 series are at the left side of the scale and not in the middle.

I would like to hide the 3rd empty series so it will look like there's only 2 series.

Have you tried hide row/column?