If-formula in series-range of chart-datasource

  • Thread starter Thread starter hglamy
  • Start date Start date
H

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
 
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
 
Back
Top