Toggle series on excel chart

Is there a way I can toggle between 2 series on a chart? I want the user to be able to select 2 options from a combo box and have it show the series based on the selection they make.
LVL 1
Lawrence SalvucciInformation Technology ManagerAsked:
Who is Participating?
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello,

yes, that is possible.

In the attached file, select a value in G1 and see the chart change.

This is called dynamic charting and is driven by range names that define the chart source, rather than fixed cell references.

If you need more information, please post your workbook for more detailed advice.

cheers, teylyn
Book4.xlsx
0
 
Lawrence SalvucciInformation Technology ManagerAuthor Commented:
Thank you for the quick response. Much appreciated!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.