Thread: How do we make each row of data into its own chart?

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 <E4C43BB9-0F84-45FA-81E7-A5991FF2E74E@microsoft.com>,
MGalbreth@discussions.microsoft.com 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.
>