Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data Selection for graph plotting
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selection of data for plotting graphs | Charts and Charting in Excel | |||
Help needed for sorting the data and plotting graph | New Users to Excel | |||
Help needed for sorting the data and plotting graph | Excel Discussion (Misc queries) | |||
Plotting Cummulative Data In A Line Graph | Charts and Charting in Excel | |||
Plotting Line Graph of Dynamic Data | Charts and Charting in Excel |