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

Group	Amount F	Amount M	Median F	Median M	Median F+M	Min F	Max M	Min M	Max M
Alpha	4	2	37500	27500	65000	20000	55000	25000	30000
Beta	2	1	37500	20000	57500	30000	45000	20000	20000
Gamma	2	0	85000	0	85000	70000	100000	0	0
Delta	2	0	55000	0	55000	50000	60000	0	0

<tbody>
</tbody>

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

Group	Amount F	Amount M	Median F	Median M	Median F+M	Min F	Max M	Min M	Max M
Alpha	4	2	37500	27500	65000	20000	55000	25000	30000
Beta	2	1	37500	20000	57500	30000	45000	20000	20000
Gamma	2	0	85000	0	85000	70000	100000	0	0
Delta	2	0	55000	0	55000	50000	60000	0	0

<tbody>
</tbody>

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]