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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Back
Top