Please ignore my post from earlier today, I've given up on that one for now.

I now just want to add lines to a column chart.

I realise I can do this by adding another series, then right clicking, chart type, line graph etc, but this only works if you have multiple values, whereas I just have data for ONE month.

So, for example, my data is showing the total amount of sick leave for quarter 1 per employee (3 days), the target amount (2 days), plus the best (1 day) and worst (6 days) from neighbouring organisations.

I would like to have 1 column for the out-turn (3 days), plus 4 lines, horizontally, for the other values.


ANYBODY help ASAP please, as I need to finish this for 40 charts (should be ok once I've created a custom chart) by 2pm GMT tomorrow.

Thanks in advance