Make lines on a graph appear with a button

  • Thread starter Thread starter geistritter
  • Start date Start date
G

geistritter

All,

I need to create a graph with 40 or so lines graphed but only one up o
the graph at a time with the use of buttons. I would really appreciat
a hand, I am very new to this level of Excel. Thanks
 
Select all the data, and create a line chart
Select a cell in the table
Choose Data>Filter>AutoFilter
From the dropdown list in one of the heading cells, select an item
The chart will display the data for that item
 
Back
Top