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!
|