How to increment a a range of cells (by one cell) which is the output to my pie chart?

[ScubaGuy]

I need a macro to increment a current range of selected cells by selecting the next (empty) row. For instance, range A1 to A20 is currently selected and attached to an existing pie chart on the same sheet as the data. Each month I add a new row of data so that the existing pie chart includes it too. So, the macro would increment the current range (A1 to A20) to A1 to A21 for the next month.

I have this same pie chart/range on 76 sheets covering 76 product inventory balances, so going sheet by sheet and manually changing the range is what I am currently doing every month. Ugh! That's why a macro would be great!

[Sean Thomas]

Hi,
you could use a number of different ways

why not use

Please Login or Register  to view this content.

that way each time you add a new row it will include it

[ScubaGuy]

I guess I better re-state my question please, to..

How to increment a CHART DATA RANGE with a macro?

[Sean Thomas]

Hi, heres a link to a site that might help with dynamic ranges that will update the chart everytime you add a row

http://chandoo.org/wp/2009/10/15/dyn...t-data-series/