Picklist Chart

Hi Excel Gurus,

Please see my attachment and I am stuck with this picklist chart option. I have added a list in B1. When I change the list I want the graph to be appear.

Issue: When I change the chart type Line. I don't want to see the other chart type. But its appearing the other chart too. wise versa I just wanted to see the selected chart type only.

Please help

Try changing "NA" in your formulas to NA()

For example C4 would become =IF(C$3=$B$1,$B4,NA())

Does that help?

BSB

hey it works

Happy to help.
Thanks for the rep point.

BSB