Changing the setting of X,Y axes

[Prue]

Hi all,

I’m struggling to achieve something.

I am working on a scatter chart (see enclosed) and I would like t
change the settings of the axes X, Y for the results to be displaye
differently.
Currently my two axes (level of power; level of importance) range fro
-5 to 5. I would like to simplify the chart and have no minus points
Instead, I was thinking of having 3 levels for power and importanc
which would be: High, Medium and Low – and have a graph lookin
something like the image attached.
I can create a drop-down menu for the power and importance column bu
how d a change the settings of xchart and axes so that it appear
correctly??

Any suggestions?

Also, the doc is coded for the two other columns and I don’t want th
change of settings to mess the coding.

I would be very grateful if someone can help as I’ve been struggling fo
a few days…

Thanks in advance :-

+-------------------------------------------------------------------
|Filename: new chart.jpg
|Download: http://www.excelbanter.com/attachment.php?attachmentid=661
|Filename: stakeholder mapping.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=662
+-------------------------------------------------------------------