Hi rabidchild,

One other idea is to generate each chart as a .gif file and save them in a
folder. From there you can print the charts, or link them in a report. This
stops the workbook from getting too big (150 chart sheets is a lot to
handle).

There is a sample workbook 'Multiple Chart Builder' at
http://edferrero.m6.net/charting.aspx that does this.

Ed Ferrero
http://edferrero.m6.net/


Hi

I have a worksheet with about 150 rows and 50 columns. I would like to
create a bar chart for each rows worth of data on a seperate worksheet,
using the column headers as the labels on the x axis and the cell
contents as the y axis (with the first cell in each row as the chart
title).

Is there a way of automatically generating all these graphs? I am
currently creating them individually.

Thanks

RC


--
rabidchild
------------------------------------------------------------------------
rabidchild's Profile:
http://www.excelforum.com/member.php...fo&userid=2627
View this thread: http://www.excelforum.com/showthread...hreadid=401451