MS Excel / VBA help thread

It's been a while since I've done any charting but I imagine you can do it as a stacked bar chart - where the x axis value for each point is actually the sum of all the points underneath.

Then give the bars no fill, and adjust the bar outline to also have no fill - there's an option somewhere to put a dot on the top of the bar portions. I'll have a go and see if I can make it work...

I've not tried TW2;s method, it's probably easier, if not:

Your data:
antibacterial soap |plain soap |control
0.5 |1 |2
1 |1.5 |3
1.2 |1.7 |3.5
1.5 |3 |4

Make a new set of data as each point in yours minus the previous one:
antibacterial soap |plain soap |control
0.5 |1 |2
0.5 |0.5 |1
0.2 |0.2 |0.5
0.3 |1.3 |0.5

Select the second table
Insert Column chart
Select all chart types
Select 'stacked line with markers'

right click on graph, 'Select Data', 'Switch / Row/Column'
Then delete all the lines, so you're just left with the points on the chart