LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
kmccormic
 
Posts: n/a
Default 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


--
kmccormic
------------------------------------------------------------------------
kmccormic's Profile: http://www.excelforum.com/member.php...o&userid=32983
View this thread: http://www.excelforum.com/showthread...hreadid=528108

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using different values for data labels Bruce Skyer Charts and Charting in Excel 3 March 20th 06 09:27 PM
Excel2003: Axis labels are truncated David Burr Charts and Charting in Excel 2 October 31st 05 10:31 PM
Number of labels on X-axis one more than number of values on Y-axi Gudrun Charts and Charting in Excel 5 August 26th 05 01:55 PM
Bar chart & Category (x) axis labels Airi A. Charts and Charting in Excel 0 March 15th 05 03:09 PM
Stop Excel from converting text labels in CSV files to Values Just Want a Label! Excel Discussion (Misc queries) 1 January 11th 05 04:51 PM


All times are GMT +1. The time now is 10:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"