Joseph:

You can do exactly what you want, however, you will need to do a little
planning and set up your data to allow the interactive selection you want.

Since your data series length is not the same for each series, the first
thing to do is create dynamic range names for each series you want to plot.

Next, you need to decide how you want to select your series to be plotted,
checkboxes or drop down selections are two options.

These links show examples of checkbox and dropdown approaches.

http://processtrends.com/pg_interact...checkboxes.htm

http://processtrends.com/pg_chart_sc...r_checkbox.htm


I'd suggest you post back with a more detailed description of your data sets
so that we can give you better advice before you jump in.

What are the X and Y axis variables? Are the data ranges comparable for the
data sheets? Is it possible to have the Y values all on one sheet? Do you
need a line chart, can you use an XY chart?

Kelly O'Day



"joecrabtree" wrote in message
...
To all,

I have a workbook with multiple worksheets labelled data1, data2,
data3, and data4. I also have one sheet called 'graph'. On worksheet
labelled 'graph' I have a line graph that currently plots the data in
sheet 'data1'. however what I want to do is as follows:

Add a dropdown menu to sheet 'graph'

Use this dropdown menu so that I can select which data is displayed in
the graph. i.e. data from 'data1' or data from 'data2' etc. The format
of the data i.e. column headings and layout is the same for each
worksheet. The length of the data is not the same however.

Does anyone have any ideas/a fix for this?

Thanks in advance for your help.

Regards

Joseph Crabtree