|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.