Can Excel produce multiple profiles of charts/tables of row data?

[Guest]

Can excel create multiple profiles based on rows of data that will be
created based on a template of row/column commands to include charts, tables
and text? In other words, if I have 225 rows of data and need to create 225
individual profiles of charts and tables based on thoise 225 rows, can excel
do that?

Thanks!

 

[Tom Ogilvy]

Yes.

Better would be to create pivot table and pivot chart. Then you can choose
one of the 255 rows to look at or sequentially look at them all by selecting
them one at a time.

 

[Guest]

Thanks, Tom! Does the pivot table and chart then allow the user to isolate
each row by indicated fileds and write a program that will produce 225
individual pages with charts and tables organized on the individual pages
based on commands?

Thank you,
Meagan

 

[Tom Ogilvy]

The point was to only create one sheet/chart/table and change which
attribute you want to look at.

If you need to produce 225 printed charts/pages, then you can write code to
select each fileds and print out the single worksheet.

If you actually must have 225 separate worksheets, then you probably can do
it, but may have to do it in several steps