Questions

Excel question

Tags:
+
0 Votes
Locked

Excel question

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.
  • +
    0 Votes
    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

    +
    0 Votes
    jimmy-jam

    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?

    +
    0 Votes
    david.wallis

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

    +
    0 Votes
    jimmy-jam

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

    +
    0 Votes
    david.wallis

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

    +
    0 Votes
    david.wallis

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

    insert - object - micrsoft graph

    then you can relabel all the columns :)

    +
    0 Votes
    jimmy-jam

    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.

  • +
    0 Votes
    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

    +
    0 Votes
    jimmy-jam

    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?

    +
    0 Votes
    david.wallis

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

    +
    0 Votes
    jimmy-jam

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

    +
    0 Votes
    david.wallis

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

    +
    0 Votes
    david.wallis

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

    insert - object - micrsoft graph

    then you can relabel all the columns :)

    +
    0 Votes
    jimmy-jam

    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.