If-formula in series-range of chart-datasource

[hglamy]

Hello there,

depending on the "True" or "False"-value of a checkbox in a worksheet,
I need to show one or the other dataseries for the X-axis in an XL-chart.

However, when I try to integrate an If-formula into the series-definition
in the datasource-dialogbox, Excel doesn't accept that.

Is there a way to make a dataseries shown dependent on a condition ?

Thank you in advance,

Kind regards,

H.G. Lamy

 

[Frank Kabel]

Hi

look at the following examples
http://peltiertech.com/Excel/Charts/ChartByControl.html
http://www.tushar-mehta.com/excel/newsgroups/dynamic_charts/index.html

Frank

 

[hglamy]

Thank you, Frank !

Regards,

H.G. Lamy

 

[Frank Kabel]

To be honest you should thank the creators of those examples ))
Regards
Frank

 

[Jon Peltier]

Frank -

Thanks for the referral!

- Jon

 

[Frank Kabel]

Hi Jon

though i've used Excel extensively since Excel 95 i was impressed by
your charting techniques (as well as those of Tushar Mehta and others).
Still Excel surprises me


Regards
Frank