Help with making multiple graphs at once

[donatello rage]

Hey first post hopefully this is in the right category and hopefuly someone here has a solution

Heres my problem

i have a lot of data that i need to graph a snapshot is below
http://img13.imageshack.us/img13/3262/picturetbw.png

so what i want to do is be able to create multiple graphs of Average KO vs Average WT for each category and im looking for a way to do this with error bars without click over and over again and creating one graph one by one

PLEASE HELP

[Paul]

Hi Donatello,

Please make sure to post your thread in the appropriate forum. I've moved the thread from the 'Tips & Tricks' forum this time, but future posts not adhering to the forum rules will be locked.

Thanks!

[shg]

Post workbooks, not pictures.

If you're looking for someone to provide code to do this (the alternative of clicking) then you'd need to provide additional information about the general structure of the sheet beyond this specific example.

An example of expected results would be appropriate as well.

None of this is the sound of me volunteering.

[broro183]

Hi Donatello,

Here are some links to automating chart creation which you may be able to adapt & apply to your challenge:

http://peltiertech.com/Excel/ChartsH...kChartVBA.html or you may find something useful on Jon's other pages, http://peltiertech.com/Excel/Charts/index.html


As Shg suggests, uploading a workbook will help people give useful answers by providing context & more explanation.

hth
Rob