Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]() 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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Using different values for data labels | Charts and Charting in Excel | |||
Excel2003: Axis labels are truncated | Charts and Charting in Excel | |||
Number of labels on X-axis one more than number of values on Y-axi | Charts and Charting in Excel | |||
Bar chart & Category (x) axis labels | Charts and Charting in Excel | |||
Stop Excel from converting text labels in CSV files to Values | Excel Discussion (Misc queries) |