Hi, 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)

or

x values: ='Sample 1'!$E$4:INDIRECT("$E$"&C1)but no luck so far

Thanks in advance,

Kakodrilo

DAGS dynamic range for charts

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

[EDIT]

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.

[/EDIT]

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.

Thank you very much. After knowing that I have to search for dynamic ranges I found the solution.

http://www.tushar-mehta.com/excel/n...

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.

Cheers,

Kakodrilo

Thanks for letting us know that we were able to help. Good luck with your project.

Ask Your Question

Weekly Poll

Do you think Monopoly should update its pieces?

Discuss in The Lounge

Poll History