Dynamic Excel Chart based upon cell column value

Simon Raine
Simon Raine used Ask the Experts™
on
I would like my excel chart range to dynamically change based upon the value in row for column A.

i.e. only include the row if the value = "Yes" and for the chart to update if value changed from no to 'Yes"

i..e in the current chart rows 9 to 13 should not be on display in the chart.

Thanks

Capture.PNG
Simon
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Consultant
Commented:
You could make a table out of the data (Cntl-T), and then filter "No".  See example attached.
EE.xlsx

Author

Commented:
Thanks

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial