chart to include new rows pasted to data set

[jrtaylor]

I apologize for probably asking a question which has already been answered here.

I have a data set which I "update" once or twice a week. Each update adds several new rows to the data sets.

Currently I am manually editing my chart's data series to include the new rows.

I have not named any data ranges. I simply refer to cell addresses in the charts.

How do I use ranges (and any formulas such as offset or indirect) to accomplish the charting of added data?

If helpful I can attach the spreadsheet.

Thanks!

[sweep]

Hi,

You need to use a dynamic range. Presuming your data in in column A, starting at A1:

Do Insert > Name > Define

names on worksheet: rng

Refers to: =OFFSET($A$1,0,0,COUNT($A:$A),1)

Then in your graph make the data values =Sheet1!rng

If you're struggling, please post an example?

[jrtaylor]

Thanks for the help. I'm taking you up on your offer to post an example.

The spreadsheet has maybe 35 columns, only two of which are used in the chart.

The shaded areas are for calculations. The white area is where I paste (and re-paste) the raw data.

A bonus would also be some way to "fill in" new rows in the shaded area each time I add new data to the white area.

Thanks!

[sweep]

Hi,

Please see attachment

[jrtaylor]

Sweep, thanks.. it works! I see how you named the ranges under "Name Manager".

Next task is to figure out how to automatically add rows to the shaded area when needed (that is, when I paste new data to the data set). I'll search the posts and if I can't find the answer will start a new thread.

Thanks again!