Conditional Pie Chart Range

[xboxer16]

Hello!,

I wanted to create a PIE chart that would be conditional on a drop down list. If the drop down list said "Febuary", then I would like the range of data that contains my income breakdown in the month of febuary.

I tried to put this on the series of the Pie chart:

=SERIES(General!$B$1,General!$A$2:$A$6,IF($D$2 = "January", General!$B$3:$B$5),1)

However, this did not work.

Suggestions are appreciated

 

[Worf]

Hello and welcome to the Board!

See if this page helps, it also contains links to other pages:

Dynamic Charts

 

[xboxer16]

Thank You