Efficiently Generate 88 New Chart Sheets

[Takeadoe]

Gang,

I've got a simple X*Y chart with year (1977-present) on the x-axis and
an estimate of deer population size on the y-axis (actually, there may
ultimately be 2 estimates/series). There is nothing really all that
fancy about it. It will be updated each year with the current year's
estimate. The problem is, I need 87 more just like it - 1 for each of
the 88 units that I manage.

I have been reading VBA and Excel books and I have yet to find an
example on how to "mass produce" a bunch of chart sheets. I take that
back - a simple "FOR NEXT" loop will generate the chart sheets. I'm at
a loss as to how to get the chart that I want with the "look" and data
that I need.

An idea thatI've had: Turn the macro recorder on and generate a
prototype chart. Cut and paste this code (after cleaning it up) into a
"FOR NEXT" loop and viola!

Clearly an oversimplification. Any sample code or other guidance would
be appreciated.

BTW the source data for each chart is all in a single worksheet and
looks like the folllowing:

County Year Population
Athens 1977 207
Athens 1978 305
Athens 2006 10,005
Belmont 1977 405
....

Mike

 

[Don Guillett]

Why overload your project with all those charts? Perhaps you can use one
where you filter on the group desired to modify that one chart.

 

[Dave Peterson]

You got a reply at one of your other posts.

Gang,

I've got a simple X*Y chart with year (1977-present) on the x-axis and
an estimate of deer population size on the y-axis (actually, there may
ultimately be 2 estimates/series). There is nothing really all that
fancy about it. It will be updated each year with the current year's
estimate. The problem is, I need 87 more just like it - 1 for each of
the 88 units that I manage.

I have been reading VBA and Excel books and I have yet to find an
example on how to "mass produce" a bunch of chart sheets. I take that
back - a simple "FOR NEXT" loop will generate the chart sheets. I'm at
a loss as to how to get the chart that I want with the "look" and data
that I need.

An idea thatI've had: Turn the macro recorder on and generate a
prototype chart. Cut and paste this code (after cleaning it up) into a
"FOR NEXT" loop and viola!

Clearly an oversimplification. Any sample code or other guidance would
be appreciated.

BTW the source data for each chart is all in a single worksheet and
looks like the folllowing:

County Year Population
Athens 1977 207
Athens 1978 305
Athens 2006 10,005
Belmont 1977 405
...

Mike

 

[Takeadoe]

Don,

That's kind of what I was thinking. Before posting I thought about a
drop down list of counties. Ultimately, I need to look at all of them.
At some point though, the drop down list is probably the way to go.

Mike