Help with automating a chart in excel 2010

[petemahoney]

Hi,

I have an excel database from which I need certain data to be filtered and used for automating certain charts. Sample data is as shown below. I was wondering whether i could use a pivot to create a chart which has the cost covered and total cost as two stacked bars, the corresponding school name on the y axis, the age and name as two columns next to the bars. Is this possible using a pivot chart or does it require a macro?
Your help is appreciated. Thanks.

School name	Cost covered	Total cost	Age	Name
X	300	1000	14	Jim
Y	500	900	15	john
Z	600	1400	16	Max

<colgroup><col><col><col span="2"><col></colgroup><tbody>
</tbody>

 

[GlennUK]

Can you please explain what you mean by

the age and name as two columns next to the bars

... it sounds like you want a separate chart object embedded within the main chart.