Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

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

Posted on 2013-01-16
4
Medium Priority
?
313 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 54

Accepted Solution

by:
Rgonzo1971 earned 2000 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 54

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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…

580 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