View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Can Excel produce multiple profiles of charts/tables of row da

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

--
Regards,
Tom Ogilvy

"meaganbz" wrote in message
...
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" wrote:

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.

--
Regards,
Tom Ogilvy

"meaganbz" wrote in message
...
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!