| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Using a Variable to Define Series
I have a worksheet that imports data from a source. It brings in data for
the past 24-hours. I want to see the last 24 hours, a 4-hour window, and a 1-hr window (not all at the same time). I have 3 buttons that change a worksheet defined variable (Defined Name) to the appropriate row value of the data to be graphed. How do I define the series to use the Defined Name? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Using a Variable to Define Series
some links on the subject,
http://peltiertech.com/Excel/Charts/Dynamics.html http://tushar-mehta.com/excel/newsgr...rts/index.html http://www.processtrends.com/TOC_dynamic_charts.htm Cheers Andy Posse John wrote: I have a worksheet that imports data from a source. It brings in data for the past 24-hours. I want to see the last 24 hours, a 4-hour window, and a 1-hr window (not all at the same time). I have 3 buttons that change a worksheet defined variable (Defined Name) to the appropriate row value of the data to be graphed. How do I define the series to use the Defined Name? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Using a Variable to Define Series
additional links:
see section "Using Defined Names to Link Charts to Data" http://www.awprofessional.com/articl...?p=374498&rl=1 Andy Pope a écrit : some links on the subject, http://peltiertech.com/Excel/Charts/Dynamics.html http://tushar-mehta.com/excel/newsgr...rts/index.html http://www.processtrends.com/TOC_dynamic_charts.htm Cheers Andy Posse John wrote: I have a worksheet that imports data from a source. It brings in data for the past 24-hours. I want to see the last 24 hours, a 4-hour window, and a 1-hr window (not all at the same time). I have 3 buttons that change a worksheet defined variable (Defined Name) to the appropriate row value of the data to be graphed. How do I define the series to use the Defined Name? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Aling multiple sets of data by header column | Excel Discussion (Misc queries) | |||
| Trying to change ColorIndex for series settings | Charts and Charting in Excel | |||
| Variable series length/range | Charts and Charting in Excel | |||
| Chart -- Source Data... -- Series dialog window | Charts and Charting in Excel | |||
| Define drop-down results that are variable and dependent upon the. | Excel Discussion (Misc queries) | |||
Linear Mode
