We have a spreadsheet where each row of data is about a separate company. We
need to make each company its own chart showing the data in the row. How do
we create multiple charts with one source document? It is a large amount of
data and we do not want to create a chart 400 times.

Pivot tables are faairly good at this
additionally
you could make a look up atble which would lookup each company one at a time
and plot the look-up table row.

"MGalbreth" wrote:

We have a spreadsheet where each row of data is about a separate company. We
need to make each company its own chart showing the data in the row. How do
we create multiple charts with one source document? It is a large amount of
data and we do not want to create a chart 400 times.

Hi MGalbreth,

You could also take a look at the 'Chart Selector' sample at
http://edferrero.m6.net/charting.aspx

Ed Ferrero
http://edferrero.m6.net

We have a spreadsheet where each row of data is about a separate company.
We
need to make each company its own chart showing the data in the row. How
do
we create multiple charts with one source document? It is a large amount
of
data and we do not want to create a chart 400 times.

See http://groups-
beta.google.com/group/microsoft.public.excel.charting/browse_thread/thr
ead/5b688f1a735101b9/63663c006bcec1b1?hl=en#63663c006bcec1b1

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
We have a spreadsheet where each row of data is about a separate company. We
need to make each company its own chart showing the data in the row. How do
we create multiple charts with one source document? It is a large amount of
data and we do not want to create a chart 400 times.