How to create a stock column chart with error bars?? (Both gender together)

[Orongo]

Hi

I have a series of data and want to create a chart looking like this
Google Image Result for http://peltiertech.com/images/2011-06/BoxPlotV6.png

where it shows min/max on the error bars, quartile 1/3 on the box and median as a scatter plot. My data is a simple table

[TABLE="width: 640"]
<tbody>[TR]
[TD]Group[/TD]
[TD]Amount F[/TD]
[TD]Amount M[/TD]
[TD]Median F[/TD]
[TD]Median M[/TD]
[TD]Median F+M[/TD]
[TD]Min F[/TD]
[TD]Max M[/TD]
[TD]Min M[/TD]
[TD]Max M[/TD]
[/TR]
[TR]
[TD]Alpha[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]37500[/TD]
[TD="align: right"]27500[/TD]
[TD="align: right"]65000[/TD]
[TD="align: right"]20000[/TD]
[TD="align: right"]55000[/TD]
[TD="align: right"]25000[/TD]
[TD="align: right"]30000[/TD]
[/TR]
[TR]
[TD]Beta[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]37500[/TD]
[TD="align: right"]20000[/TD]
[TD="align: right"]57500[/TD]
[TD="align: right"]30000[/TD]
[TD="align: right"]45000[/TD]
[TD="align: right"]20000[/TD]
[TD="align: right"]20000[/TD]
[/TR]
[TR]
[TD]Gamma[/TD]
[TD="align: right"]2[/TD]
[TD]0[/TD]
[TD="align: right"]85000[/TD]
[TD]0[/TD]
[TD="align: right"]85000[/TD]
[TD="align: right"]70000[/TD]
[TD="align: right"]100000[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]Delta[/TD]
[TD="align: right"]2[/TD]
[TD]0[/TD]
[TD="align: right"]55000[/TD]
[TD]0[/TD]
[TD="align: right"]55000[/TD]
[TD="align: right"]50000[/TD]
[TD="align: right"]60000[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
</tbody>[/TABLE]


Here F = Female, M=Male and the chart should show all calculation for both gender together (I have another thread up where the gender are separated with the Title (How to create a stock column chart with error bars?? (Both gender separated))

Please help me with a (pseudo) code, I have never used VBA for creating chart, and this is my first

 

[Orongo]

Re: How to create a stock column chart with error bars?? (Both gender separated)

Hi I am sorry, I have copy paste the wrong text. This is a question with both gender separated

I have a series of data and want to create a chart looking like this
Google Image Result for http://peltiertech.com/images/2011-06/BoxPlotV6.png

where it shows min/max on the error bars, quartile 1/3 on the box and median as a scatter plot. My data is a simple table

[TABLE="width: 640"]
<tbody>[TR]
[TD]Group[/TD]
[TD]Amount F[/TD]
[TD]Amount M[/TD]
[TD]Median F[/TD]
[TD]Median M[/TD]
[TD]Median F+M[/TD]
[TD]Min F[/TD]
[TD]Max M[/TD]
[TD]Min M[/TD]
[TD]Max M[/TD]
[/TR]
[TR]
[TD]Alpha[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]37500[/TD]
[TD="align: right"]27500[/TD]
[TD="align: right"]65000[/TD]
[TD="align: right"]20000[/TD]
[TD="align: right"]55000[/TD]
[TD="align: right"]25000[/TD]
[TD="align: right"]30000[/TD]
[/TR]
[TR]
[TD]Beta[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]37500[/TD]
[TD="align: right"]20000[/TD]
[TD="align: right"]57500[/TD]
[TD="align: right"]30000[/TD]
[TD="align: right"]45000[/TD]
[TD="align: right"]20000[/TD]
[TD="align: right"]20000[/TD]
[/TR]
[TR]
[TD]Gamma[/TD]
[TD="align: right"]2[/TD]
[TD]0[/TD]
[TD="align: right"]85000[/TD]
[TD]0[/TD]
[TD="align: right"]85000[/TD]
[TD="align: right"]70000[/TD]
[TD="align: right"]100000[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]Delta[/TD]
[TD="align: right"]2[/TD]
[TD]0[/TD]
[TD="align: right"]55000[/TD]
[TD]0[/TD]
[TD="align: right"]55000[/TD]
[TD="align: right"]50000[/TD]
[TD="align: right"]60000[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
</tbody>[/TABLE]


Here F = Female, M=Male and the chart should show all calculation for F and M separated (I have another thread up where the gender are together with the Title (How to create a stock column chart with error bars?? (Both gender together))

Please help me with a (pseudo) code, I have never used VBA for creating chart, and this is my first[/QUOTE]