Chart Creation based upon if statement

[willcass]

Hi,

I have a list of IF statements in a table which output an "X" if a condition is met. Is it possible to automatically create charts for the rows which only have an X next to them - I presume VBA is the only solution to this ?

More importantly, thanks to everyone on this forum - some of the answers to other peoples queries here have been life savers!!

Regards

Will

 

[Andrew Poulsom]

Welcome to MrExcel.

If you AutoFilter your table for that column equals x, Excel will plot only the visible cells if that is checked under Tools|Options|Chart tab.

 

[willcass]

thanks for you help - will give it a go now!