How to colour quardrants of a point chart

[uriahpete]

Hi Everyone,

I have to prepare a point chart in which every quarter is filled in a different colour. For example quarter with the possitive numbers on the vertical and horizontal axis is green, quarter with the negative numebers on the vertical and horizontal axis is in red, and other to in e.g. yellow.
To have some idea how it should look like, please see that chart:

http://help.arcgis.com/en/businessan...meplanmap.html

I'm not sure if I explained it clearly but hope you know what I mean. Is it possible to do such a chart in excel?

[martindwilson]

http://peltiertech.com/WordPress/exc...nt-background/

[uriahpete]

Thanks martindwilson but I've seen that site.
It's not realy what I want to do. On this site it's shown how to colour quadrants but only for one quadrant of the chart (with possitive figures on both axis).
What I want to get is to colour quadrants of the chart which are created by an intersection of the chart's axis. Do you know what I mean?
chart.png

[Andy Pope]

If you put the column series on the secondary axis you can use +/- xy-scatter.

[uriahpete]

Andy,

It looks fantastic!
Did you do that base on the info from the site given by a martindwilson? I will have to go through this one more time.
Thank you.

[uriahpete]

Andy,

It looks fantastic!
Did you do that base on the info from the site given by a martindwilson? I will have to go through this one more time.
Thank you.

[Andy Pope]

I used a slightly different approach to Jon, dummy series as column charts, due to the negative values.

Whlst it appears negative values will work the axis is not labelled correctly

[uriahpete]

Andy, have you found the way to have the coloured quadrants adjust when you change the data? I mean there is no problem when axis cross in the middle of the chart. Otherwise the chart doesn't look good. The only way out I've found is to fix a minimum and maximum value of the x axis and the absolute values of them have to be the same.

chart2.png

[Andy Pope]

This variation uses the area data series. I have set it up so you can specify any percentage for horizontal or vertical split.

Area data series are on the primary axis, scatter on the secondary.

[uriahpete]

Thanks Andy that's nearly perfect.
You showed me the method how to adjust coloured quadrants but still when I change data I have to manipulate with the percentiges (horizontal % and vertical%).

To manipulate these percentages I've written a simple code which gives me in the cell f6 and f7 these numbers calculated based on the min and max of vartical and horizontal axis (these min and max are set automaticly by excel based on the actual data):

Please Login or Register  to view this content.

But something is wrong with these code because the percentages are adjusted but the workbook breaks down. Do you know what is wrong and how to fix it?

[Andy Pope]

try

Please Login or Register  to view this content.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

[uriahpete]

Thank you Andy very much.
Now I have exactly what I wanted.

[martindwilson]

good aint he!