Hi Everyone,

I have a spreadsheet that has 230 rows of data representing the number
of car dealerships in one region. I have 10 salespeople who service
this region with about 20 dealers each. The spreadsheet contains all
dealers and has subtotals of each salesperson throughout. I would like
to take this data and create a graph for each dealership which shows the
data for that dealer, the average of dealers for their salesperson, and
an overall average for the all dealers. This means there will be three
bar graphs for each graph. I need a macro that will create take each
row of data and create a graph and place it in one worksheet.

Thanks in advance for your help!!

Regards,

Ben


--
Big Ben
------------------------------------------------------------------------
Big Ben's Profile: http://www.excelforum.com/member.php...fo&userid=6431
View this thread: http://www.excelforum.com/showthread...hreadid=271653