Using a Variable to Define Series

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Posse John - 25 Aug 2006 08:32 GMT

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?

Reply to this Message

Andy Pope - 25 Aug 2006 13:39 GMT

some links on the subject,

http://peltiertech.com/Excel/Charts/Dynamics.html
http://tushar-mehta.com/excel/newsgroups/dynamic_charts/index.html
http://www.processtrends.com/TOC_dynamic_charts.htm

Cheers
Andy

> 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
[quoted text clipped - 4 lines]
>
> How do I define the series to use the Defined Name?

Signature

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Reply to this Message

bda75 - 30 Aug 2006 13:18 GMT

additional links:
see section "Using Defined Names to Link Charts to Data"
http://www.awprofessional.com/articles/article.asp?p=374498&rl=1

Andy Pope a écrit :

> some links on the subject,
>
[quoted text clipped - 13 lines]
> >
> > How do I define the series to use the Defined Name?

Reply to this Message