One chart that shows one data series out of ten at a time

  • Thread starter Thread starter Joseph Sichelstiel
  • Start date Start date
J

Joseph Sichelstiel

Hi. I'm trying to make one chart that can displays ten
data series, but one at a time. I have data for ten
plants
by month. I have made a chart that has the ten plants
display simultaneously, but the chart is too crowded to
be of much use.

Is there a way to make one chart, and then have the user
click on buttons to display one plant's data at a time? I
don't want to make ten seperate line charts.

I've looked in the F1 help, but I don't believe I'm
looking
up the correct terms.

Thanks for any help.
Joe
 
Hi Joseph,

Have a look at the dynamic chart tutorial, No.4, on Tushar's site.
(http://www.tushar-mehta.com/)

Also try Jon's site. I can't give you the specific page as due to the
sites popularity, it's temporarily unavailable.
(http://www.geocities.com/jonpeltier/Excel/index.html)


Joseph said:
Hi. I'm trying to make one chart that can displays ten
data series, but one at a time. I have data for ten
plants
by month. I have made a chart that has the ten plants
display simultaneously, but the chart is too crowded to
be of much use.

Is there a way to make one chart, and then have the user
click on buttons to display one plant's data at a time? I
don't want to make ten seperate line charts.

I've looked in the F1 help, but I don't believe I'm
looking
up the correct terms.

Thanks for any help.
Joe
Click to expand...

--

Cheers
Andy

http://www.andypope.info
 
Back
Top