Y-axis labels or values

Hello!

I've searched through the posts, and couldn't find this question listed. I want to change the values of the Y-axis to reflect the definitions I've chosen instead of numbers.

I'm using a simple column chart, I'm not 100% sure if it's the chart or the way I've set up my table that's the problem. Below is a simplified example of what I'm trying to do. I want the series data, or the columns/X-axis to reflect the items Spending, Expenses, Budget. I want to have the values of the Y-axis to list Low, Medium, High, and for the columns to go to the appropriate level for the Y-axis.

Spending Expenses Budget
Low 1
Medium 2
High 3

I also tried this format for the table.


Spending Expenses Budget
Low 1 1 1
Medium 1 1
High 1


Thank you,
Kara McCormic

Type Spending, Expenses, Budget in B1:D1
In B2:D2 enter values 1, 2, 3
Make chart from A1:D2
Format the y-axis: white font, transparent background: this hides the
numbers on the y-axis
With chart selected, in Formula bar Low.
This makes a text box that can be dragged to line up with the gridline at
y=1
Same for next two
Alternatively use Bovey XY Chartlabeler (www.appspro.com) - it works with
all chart types
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"kmccormic" <[email protected]> wrote
in message news:[email protected]...
>
> Hello!
>
> I've searched through the posts, and couldn't find this question
> listed. I want to change the values of the Y-axis to reflect the
> definitions I've chosen instead of numbers.
>
> I'm using a simple column chart, I'm not 100% sure if it's the chart or
> the way I've set up my table that's the problem. Below is a simplified
> example of what I'm trying to do. I want the series data, or the
> columns/X-axis to reflect the items Spending, Expenses, Budget. I want
> to have the values of the Y-axis to list Low, Medium, High, and for the
> columns to go to the appropriate level for the Y-axis.
>
>
> Spending Expenses Budget
> Low 1
> Medium 2
> High 3
>
>
> I also tried this format for the table.
>
>
> Spending Expenses Budget
> Low 1 1 1
> Medium 1 1
> High 1
>
>
> Thank you,
> Kara McCormic
>
>
> --
> kmccormic
> ------------------------------------------------------------------------
> kmccormic's Profile:
> http://www.excelforum.com/member.php...o&userid=32983
> View this thread: http://www.excelforum.com/showthread...hreadid=528108
>

Hello Bernard,
Thank you for your response. I'm getting lost at the point where you mention "in formula bar Low." I'm not sure what you're referring to.

As an alternative to making the font white for the Y-axis, you can actually tell the chart not to display any values at all by going to Chart Options/Axes and unchecking "Value at Y axis."

I'll definitely check out that site.

Cheers,
Kara

Originally Posted by Bernard Liengme

Type Spending, Expenses, Budget in B1:D1
In B2:D2 enter values 1, 2, 3
Make chart from A1:D2
Format the y-axis: white font, transparent background: this hides the
numbers on the y-axis
With chart selected, in Formula bar Low.
This makes a text box that can be dragged to line up with the gridline at
y=1
Same for next two
Alternatively use Bovey XY Chartlabeler (www.appspro.com) - it works with
all chart types
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"kmccormic" <[email protected]> wrote
in message news:[email protected]...
>
> Hello!
>
> I've searched through the posts, and couldn't find this question
> listed. I want to change the values of the Y-axis to reflect the
> definitions I've chosen instead of numbers.
>
> I'm using a simple column chart, I'm not 100% sure if it's the chart or
> the way I've set up my table that's the problem. Below is a simplified
> example of what I'm trying to do. I want the series data, or the
> columns/X-axis to reflect the items Spending, Expenses, Budget. I want
> to have the values of the Y-axis to list Low, Medium, High, and for the
> columns to go to the appropriate level for the Y-axis.
>
>
> Spending Expenses Budget
> Low 1
> Medium 2
> High 3
>
>
> I also tried this format for the table.
>
>
> Spending Expenses Budget
> Low 1 1 1
> Medium 1 1
> High 1
>
>
> Thank you,
> Kara McCormic
>
>
> --
> kmccormic
> ------------------------------------------------------------------------
> kmccormic's Profile:
> http://www.excelforum.com/member.php...o&userid=32983
> View this thread: http://www.excelforum.com/showthread...hreadid=528108
>