Chart Help - Multi chart type

[EMY245]

Hello,

Looking for some help / advice please.

I have the below table of data - which i have created into a stacked bar chart to show each band and the equivalent band widths (minimum-maximum). The chart then has a line chart over it to show the average at each band.

Band	Average	Band Minimum	Band Mid	Band Max	Band Width
A	£120,000	£103,000	£115,000	£130,000	£27,000
B	£110,000	£80,000	£95,000	£110,000	£30,000
C	£86,000	£65,000	£79,200	£90,000	£25,000
D	£65,000	£50,000	£60,000	£70,000	£20,000

<tbody>
</tbody>

What i would like to do is now find a way to plot individual data points on the relevant bars (/ chartcolumns)
I.e.- my data is set out like this:

[TABLE="width: 500"]
<tbody>[TR]
[TD]Band[/TD]
[TD]Data[/TD]
[/TR]
[TR]
[TD]A
[/TD]
[TD]100,000[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]105,000[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]150,000[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]110,000[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]90,000[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]130,000[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]85000[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]76000[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]90000[/TD]
[/TR]
</tbody>[/TABLE]

But i don't know how i can get this to be plotted as individual data points (presumably scatter chart) against the relevant band (a,b,c or d).

Can anyone please advise?

Apologies if unclear, it's difficult without being able to copy in the charts.

Emily

 

[thisoldman]

I haven't made a bar chart version of your data. Here's a column chart version of what I think you want;

The example spreadsheet is available at: https://www.dropbox.com/s/4fx1bcbu7w3ryq0/combo_chart_EMY245.xlsx?dl=0

I'm too tired to write up a tutorial tonight. If you can download the file and find you need a bit of explanation, just ask. I'll write something up tomorrow.

I might give a bar chart version a try, but not today.