I am working on a simple line graph. I am trying to colour sections of the plot area different colours (values 0-3 yellow, 3-4 orange, 4+ yellow) to reflect banding of indicators. I have tried doing this by drawing rectangles and filling them, but these then hide the data series and Send to Back does not seem to do anything.
I have looked at Conditional Formatting but this seems more complicated than I need. I have also found this post http://www.mrexcel.com/board2/viewtopic.php?t=227909 which seems to say that what I want to do is only possible on Macs, not on PCs.
Can anyone advise me whether there's a simple way to do this or whether I need to get my mind round conditional formatting?
Many thanks for your help.
I have looked at Conditional Formatting but this seems more complicated than I need. I have also found this post http://www.mrexcel.com/board2/viewtopic.php?t=227909 which seems to say that what I want to do is only possible on Macs, not on PCs.
Can anyone advise me whether there's a simple way to do this or whether I need to get my mind round conditional formatting?
Many thanks for your help.