I have posted a workbook that provides the requested interactive user
selection of sheet, variable, start time, time increment.

This example uses dynamic range names. Indirect function is used with he
Offset formula to allow dynamic sheet names based on user selection of data
sheet.

The sheet list is updated with a macro.

The min X axis is selectable with scroll bar. User has drop down selection
for time interval.

http://processtrends.com/toc_chart_doctor.htm

Kelly O'Day
http://processtrends.com




"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