Using INDIRECT in named range for chart data series

I

ionajewel

I recently read a post that described how to use the indirect function to
define named ranges for a chart series. I attempted to do the same, but still
get a message from the data series editor that my formula contains an invalid
reference. This is the formula for the series:

=SERIES("Load",Data!Time,Data!Load,1)

and Time is defined in the Data worksheet as:

=INDIRECT(Data!$Q$10):INDIRECT(Data!$Q$11)

Load is defined as:

=INDIRECT(Data!$Q$6):INDIRECT(Data!$Q$7)

Where the values in Q6, Q7, Q10, and Q11 refer to the desired starting and
ending addresses of the series, built using the address function.
e.g.
Q6 = address(Q1, 4) where Q1 is user input start of test line number
so
Q6 = $D$108 when the user inputs '108'

When I view the selected data in the Names menu, all the correct cells are
selected, but the names for some reason cannot be used in the chart. I am
completely confounded. Please help.
 
I

ionajewel

I solved this problem by defining the range using the indirect function,
although my solver is now considerably slowed.
 

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

Chart SERIES OFFSET 5
Creating a Chart on form from selected data in query. 0
Copying Named Ranges in Chart Series 1
Data points in chart incorrect 0
Using INDIRECT in the SERIES function...possible? 1
Using a Cell Value to Adjust a Data Series for a Plot 2
Display Name of each Data Series 1
User Selectable Series and Number of Series for Line Chart 2

Top