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
shogun5Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Gustav BrockCIOCommented:
You can use:

Chr([YourNumber])

Chr(66) => B

/gustav
0
shogun5Author Commented:
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
0
Gustav BrockCIOCommented:
Can't you have both in your query?
I don't do charting in Access, sorry.

/gustav
0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

shogun5Author Commented:
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.
0
Gustav BrockCIOCommented:
But why not use the letters? They will be sorted the same way as the numbers.

/gustav
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
shogun5Author Commented:
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. (screenshotsscreenshotsscreenshots)
0
Gustav BrockCIOCommented:
I guess it should count items not values.
But I'm not familiar with this.

/gustav
0
shogun5Author Commented:
THanks!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Office

From novice to tech pro — start learning today.