Software

Ask something
Question Locked

Excel question

0 helpful
8 replies

by jiminpa

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I am a self proclaimed excel nit wit so hopefully this is an easy question. I am helping a friend with a chart for a school project in excel. I used the chart wizard to make the chart and it looks nice. Problem is, the Y-axis isn't what I want. I want the Y-axis to have a word that represents a percentage. Right now the percentage value is along the y-axis. Is there a way behind the scenes in excel to make a regular word = a number for the chart to interpret? I hope that makes sense. Thanks.

8 replies

by david.wallis

name the axis in the chart wizard, think its step 3 of 6 or something around there after you have chosen which data you want to use

by jiminpa

I wish I could post a picture so I could show you what I was talking about. Along the Y-Axis there are percentages right now. Let's say I wanted to have 90% = high and instead of having 90% show up on the Y-Axis The word high would show up where 90% should be. Does that make a little more sense?

by jiminpa

I have to enter text here because it told me so but there is nothing useful. ;-)

by david.wallis

had a play and couldnt get it to do it, you must be able to do that though!

by david.wallis

i found out instead of doing the graph wizard, do this..

insert - object - micrsoft graph

then you can relabel all the columns :)

by jiminpa

I agree there must be a way to do it and I have been playing around with scripting in the background. For the scope of this project I think the simpler the better. I don't want to be jumping through so many hoops for a simple spreadsheet. Maybe I'll play with it in my plethera of free time ;-)
Thanks.

This discussion is closed to new replies.