LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 5th 12, 06:15 PM
Junior Member
First recorded activity by ExcelBanter: Nov 2012
Posts: 1
Default Changing the setting of X,Y axes

Hi all,

Iím struggling to achieve something.

I am working on a scatter chart (see enclosed) and I would like to change the settings of the axes X, Y for the results to be displayed differently.
Currently my two axes (level of power; level of importance) range from -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 importance which would be: High, Medium and Low Ė and have a graph looking something like the image attached.
I can create a drop-down menu for the power and importance column but how d a change the settings of xchart and axes so that it appears correctly??

Any suggestions?

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

I would be very grateful if someone can help as Iíve been struggling for a few daysÖ

Thanks in advance :-)
Attached Images
Attached Files
File Type: zip stakeholder (33.2 KB, 84 views)

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Code about setting Y Axes scale. fujing1003[_2_] Charts and Charting in Excel 3 December 11th 07 12:29 PM
XL2002 - Setting same MaxValue on 2 axes... Trevor Williams Excel Programming 2 May 1st 07 12:55 PM
Setting axes for 3-dimensional charts owc Charts and Charting in Excel 0 March 17th 06 08:20 PM
setting chart axes Jon Peltier[_7_] Excel Programming 0 July 14th 04 06:51 PM
setting chart axes nath Excel Programming 0 July 14th 04 10:59 AM

All times are GMT +1. The time now is 05:58 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright ©2004-2021 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"


Copyright © 2017