Excel chart and INDIRECT

April 15, 2009 at 18:47:34
Specs: Windows XP

I have been using INDIRECT to tell my functions which row to use for the calculations. Now I need to plot the data in a column until a row (different in each worksheet) and I would like the chart to read that row from the same cell so I do not have to change manually the data range for every sheet.

I have tried things like this:

x values: ='INDIRECT("Sample 1'!$E$4:$E$"&C1)
x values: ='Sample 1'!$E$4:INDIRECT("$E$"&C1)

but no luck so far

Thanks in advance,

See More: Excel chart and INDIRECT

Report •

April 15, 2009 at 21:02:11
DAGS dynamic range for charts

Report •

April 15, 2009 at 21:14:40
Thank you for the help. However, MS Office 2003 does not have the function DAGS. I am afraid I am stuck as I was at the beginning. I will need something more specific.

Thank you very much

What I meant in the question is that I have a column with a number of items, but I do not want to plot all, I want to plot only up to row 233, because that's the row I am using for all the calculations derived from these data.

I set a cell where the formulas read the 233 and use it (with INDIRECT).

I want to make the chart to plot up to the row 233 based on the value of that cell (or any other row that I specify with the cell).

The easy way is simply delete the data after row 233, but I want to keep them in the sheet as I need them for the next set of calculations.

Thank you very much in advance.

Report •

April 16, 2009 at 02:24:33
DAGS = do a google search.

a good guide is here:

from microsoft

Report •

Related Solutions

April 16, 2009 at 05:48:30
As jon k pointed out, I was suggesting a Google search for info on dynamic ranges for use with charts.

It's a fairly common exercise, but a little lengthy to explain in this forum and very specific to the ranges you will be working with.

Report •

April 19, 2009 at 17:14:57
Thank you very much.

After knowing that I have to search for dynamic ranges I found the solution.


Explains what I was looking for.

Just to say that I found this forum when looking up the solution in internet, but not knowing the right terms to search it was impossible to find it. Thank you again for pointing in the right direction.


Report •

April 19, 2009 at 19:56:33
Thanks for letting us know that we were able to help.

Good luck with your project.

Report •

Ask Question