Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can Excel produce multiple profiles of charts/tables of row data?
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can Excel produce multiple profiles of charts/tables of row data?
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! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can Excel produce multiple profiles of charts/tables of row da
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! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
new datasource produce no tables | Setting up and Configuration of Excel | |||
Excel Charts with Data Tables | Excel Worksheet Functions | |||
Adding new data to tables and charts in excel sheets from 97/2003 | Excel Worksheet Functions | |||
Struggling to produce INCREDIBLY simple charts with Excel (v2003) - any recommendations? | Charts and Charting in Excel | |||
quickly select data to produce charts | Charts and Charting in Excel |