Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Efficiently Generate 88 Chartsheets
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Efficiently Generate 88 Chartsheets
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Efficiently Generate 88 Chartsheets
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Efficiently Generate 88 Chartsheets
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto generate email | Excel Discussion (Misc queries) | |||
generate a random number and use if function to generate new data | Excel Worksheet Functions | |||
Generate random numberes using reference to the other cell. | Excel Worksheet Functions | |||
How to generate a random list of weekDAYS between two dates? | Excel Worksheet Functions | |||
generate report thru pracle to excell | Excel Discussion (Misc queries) |