asked on

How do I convert numbers to letters on y-axis in MS Access chart

Dear Experts,

How do I convert numbers to letters on my chart in MS Access. (please see screenshot). The values come in as Letters. I convert the values in the query to numbers using Asc(string) to get the values on the y-axis.

The problem is is that users do not understand that 66 equals a 'B'. I need to somehow convert that letter back from a number so the y-axis shows Letters again.

Any suggestions? Can you provide example of how to do this?

Thanks

M
screenshot.png

Gustav Brock

You can use:

Chr([YourNumber])

Chr(66) => B

/gustav

Mike Rudolph

ASKER

Hello!

Sorry....dumb question but where do I put this formula? I don't think it will work in the query because I need numbers initially for the y-axis. So do I put in the chart somewhere?

M
screenshot1.png
screenshot2.png

Gustav Brock

Can't you have both in your query?
I don't do charting in Access, sorry.

/gustav

Mike Rudolph

ASKER

Well, I already have letters in the query from the actual data. What I need to be able to do is to display those letters on the y-axis of the chart from the numbers that were generated to create the values on the y-axis.

It's really odd that Microsoft makes us jump through hoops to do what I would assume is a very common request. There should be a way to 'mask' these values some how.

ASKER CERTIFIED SOLUTION

Gustav Brock

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Mike Rudolph

ASKER

Well that would be wonderful if it worked that way but when I only use the letters the program tries to count the letter but can't. (