Using a Variable to Define Series

P

Posse John

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Visio: copy text of a master shape to User-define Cells (Variable) 0
Dynamic series in rows 1
Defining variables as row numbers 1
Can you input multiple series names and values with a single definedname ? 0
Using INDIRECT in named range for chart data series 1
Can a chart series (row-based) occupy more than one row 2
Cannot Add Error Bars for individual data points! 1
XY scatter plot with more than 32000 rows in Excel 2003 0

Top