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

Hi

I have a series of data and want to create a chart looking like this

tmp0.jpg
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

tmp.jpg

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

Hi all, I was able to solve it in a way. Here is the code for anyone wanting to do a chart with boxes and error bars

Please Login or Register  to view this content.