Solved

How do I conditionally change the y-axis values on chart in Excel?

Posted on 2013-01-16
4
308 Views
Last Modified: 2013-01-17
Dear Experts,

My y-axis scale goes from 0 to 17. How to I change the data points to show letters of the alphabet respectively, i.e. A=1, B=2, C=3, etc. so the data I pull in is numeric but the y-axis displays letters. Can I do some kind of conditional statement? I want the scale to show A to Q.

Thanks!
0
Comment
Question by:shogun5
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 51

Accepted Solution

by:
Rgonzo1971 earned 500 total points
ID: 38785930
0
 

Author Comment

by:shogun5
ID: 38785957
Thanks! But I am working a government computer and cannot download and install any Excel addins. I need to figure this one out with the Existing Excel software.
0
 
LVL 51

Expert Comment

by:Rgonzo1971
ID: 38786042
Hi,

Follow the the instructions
http://peltiertech.com/Excel/Charts/Y_CategoryAxis.html

If you cannot use an add-in you have to hide the normal y- axis, give labels to the dummy serie data points, then place the labels left from the data points, and then manually change the text of each label

You could use this macro to add labels

http://support.microsoft.com/kb/213750/en-us

Regards
0
 

Author Closing Comment

by:shogun5
ID: 38786867
Okay...thanks! I ended downloading this add in on my home computer and it worked like a charm!
0

Featured Post

[Webinar] How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

724 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question