Creating Pivot Charts in Excel

well creating charts in excel is very very easy, I am using Microsoft Excel 2007.. yeah yeah its kinda old..

i never tried it in Open Office.. hmm....hmm..well.this is my data for my example....

click the under "Insert; tab click the "Pivot Table" icon, you will get a dropdown,
select the "Pivot Chart"

here's a better look :)

Once you click you'll get a popup

You get this.. well i left the default options as it is....

now lets create that Chart..
lets go the "PivotTable Field List"

click the one field, you'll get a column in the sheet.. mAGiKaL!!!! :))

the chart....