Efficiently Generate 88 New Chart Sheets

  • Thread starter Thread starter Takeadoe
  • Start date Start date
T

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
 
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.
 
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
Click to expand...
 
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
 
Back
Top