You can use an additional data series with error bars to draw the dividers.
Using you example workbook put the following in the cells
....continue thru to cell
G4:G45 = 0
Use the Source Data dialog to add a new data series. Call it Manager
Select the new data series and change it to the secondary axis and chart
type xy scatter.
For the secondary y axis format that to have no tickmarks or labels with
a Maximum scale of 1
Again using the Source data dialog select the new data series and set
the X value to F4:F45 and the Y values to G4:G45
Format the data series again, removing the data labels, set the marker
and line styles to none. On the Y error bars tab set the custom + range
Now format the error bars to be red, thicker and with no end marker.
You may want to make the grid lines lighter to give the dividers more
> Thanks for the reply,
> Unfortunatley, this technique wont work with the way I have the graphs
> laid out.
> It wipes out the layout of the bottom axis.
> Does anyone have any other idea's please?
> Thanks in advance
Andy Pope, Microsoft MVP - Excel