Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Changing y axis labels
Hi,
I have a basic column graph in Excel 2003. The source is a grid of cells with a text label along the top (represented by the x axis on the graph), text labels along the left side (represented by the coloured bars in the graph) and numbers within the grid which are the values (represented by the y axis). I'd like to know if I can change the labels of the y axis to be something like Poor, Good, Excellent (each a range of values) rather than the number values. thanks jc |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Changing y axis labels
Hi,
You can add a dummy series to the chart to plot textual Y axis labels. The new series would be xy-scatter and the data label can hold the required text. You can either manually edit the text or use a free addin to link data labels to cells. http://www.appspro.com/Utilities/ChartLabeler.htm Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "jc" wrote in message ... Hi, I have a basic column graph in Excel 2003. The source is a grid of cells with a text label along the top (represented by the x axis on the graph), text labels along the left side (represented by the coloured bars in the graph) and numbers within the grid which are the values (represented by the y axis). I'd like to know if I can change the labels of the y axis to be something like Poor, Good, Excellent (each a range of values) rather than the number values. thanks jc |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 text labels in category axis - missing labels | Charts and Charting in Excel | |||
xy-scatter-labels disappear when x-axis is changed into time-axis (XL07) | Charts and Charting in Excel | |||
changing the location of the x axis labels | Charts and Charting in Excel | |||
XL2003 - Changing X-axis labels in XY Scatter... | Charts and Charting in Excel | |||
Changing Y-Axis Labels from Numerical to Textual | Charts and Charting in Excel |