Use a Dropdown List to Switch between a Table or Chart

  • By Doug H
  • 9 August, 2017
  • Comments Off on Use a Dropdown List to Switch between a Table or Chart

Sometimes you want to see a Table and sometimes you’d want to see a Chart.  How about both?  And have the option to switch between both?  It like having a button to go between a table and chart.  This tip will step you through how to create not a button but a more descriptive drop down that informs you to choose between viewing your data as a table or a colorful chart.  How’s that for power!  It’s a bit more involved in creating this, but not too difficult.  To see the magic check out the video.

 

Categories: Excel 2007 and up

Comments are closed.

Read previous post:
Use a Dropdown List to Switch between a Table or Chart

Sometimes you want to see a Table and sometimes you'd want to see a Chart.  How about both?  And have...

Close