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
|