Question

Locked

Excel question

By jimmy-jam ·
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.

This conversation is currently closed to new comments.

8 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

you can

by david.wallis In reply to Excel question

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

Collapse -

Not exactly

by jimmy-jam In reply to you can

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?

Collapse -

hmmmmmmmmm

by david.wallis In reply to Not exactly

im going to have aplay :)
what version have you got?

Collapse -

2003

by jimmy-jam In reply to hmmmmmmmmm

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

Collapse -

no luck

by david.wallis In reply to 2003

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

Collapse -

try this

by david.wallis In reply to no luck

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

insert - object - micrsoft graph

then you can relabel all the columns :)

Collapse -

It'll do

by jimmy-jam In reply to try this

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.

Back to Software Forum
8 total posts (Page 1 of 1)  

Software Forums