Hi,
I am trying to create an xy scatter graph with four POSITIVE quadrants, is there any way to do this? I can only seem to get:
x positive, y positive
x negative, y positive
x negative, y negative
x positive, y negative
I would like both x and y to go from 1-7 with the axis intercepting at 4.
Alternatively, I have seen this:
http://peltiertech.com/Excel/Charts/ColoredQuadrantBackground.html
however, I cannot get any further than doing the coloured quadrant background, i.e. can't figure out how to put in my real data as I am using Excel 2007 and the instructions are for the old excel versions.
Please help!
Thank you x
I am trying to create an xy scatter graph with four POSITIVE quadrants, is there any way to do this? I can only seem to get:
x positive, y positive
x negative, y positive
x negative, y negative
x positive, y negative
I would like both x and y to go from 1-7 with the axis intercepting at 4.
Alternatively, I have seen this:
http://peltiertech.com/Excel/Charts/ColoredQuadrantBackground.html
however, I cannot get any further than doing the coloured quadrant background, i.e. can't figure out how to put in my real data as I am using Excel 2007 and the instructions are for the old excel versions.
Please help!
Thank you x