Solved

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

Posted on 2013-01-16
4
302 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
  • 2
  • 2
4 Comments
 
LVL 48

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 48

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

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

705 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now