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
<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
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