|
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 |
Y-axis labels or values
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" wrote in message ... 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 |
Y-axis labels or values
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 Bernard Liengme Wrote: 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" wrote in message ... 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 -- kmccormic ------------------------------------------------------------------------ kmccormic's Profile: http://www.excelforum.com/member.php...o&userid=32983 View this thread: http://www.excelforum.com/showthread...hreadid=528108 |
| All times are GMT +1. The time now is 07:08 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com