Horizontal Stack Bar Chart with Scatter Values Poblems

Hi folks

I知 using Excel 2003 and I知 trying to generate a combined HORIZONTAL stacked bar chart with a scatter chart.

I have been able to do this with a VERTICAL stacked bar chart with a scatter chart (thanks to Andy Pope - took his idea from another post and used it) but Excel states some chart types cannot be combined with other chart types and am unable to create the horizontal version I need.

The data below should be First, Second and Third "quartiles" in a 0 to 100 scale horizontal stacked bar chart with the Previous and Current values (possibly using a secondary 0 to 100 scale) as a scatter chart on the relevant stacked bar


First Second Third Previous Current
A 76.5 80 83.5 50 85.7
B 77.5 99 120.5 19.8 48.8
C 55.75 62.5 69.25 77.8 96.3



Does anyone know of a solution, even if it means using a macro and VBA to generate the chart?

Here's hopeing someone out there can help ...

NoCanDo