Can i use the IF function in a chart to choose its data series?

[Guest]

Hi all,

I am currently making a chart that needs to take its data from 1 of 2
series', depending on whether cell A1 contains the number 1 or 2. I tried to
use the IF function to do this "=IF(A1=1, Range 1, Range 2)", but it just
keeps telling me i cant use the IF function in a chart. I cannot find a way
to achieve this, and its pretty critical i can, otherwise i'm going to have
to start a weeks worth of work again!

Thanks
Edd

 

[Andy Pope]

Hi,

The series data references can not handle formulas directly, only range
references. In order to make the chart dynamic you can either create
another set of cells that contain your IF() formula and then chart those
cells. Or use named ranges that are dynamic. For more information on
those see these explanations.

http://peltiertech.com/Excel/Charts/Dynamics.html
http://www.tushar-mehta.com/excel/newsgroups/dynamic_charts/index.html

Cheers
Andy