How to rename the values on Y Axis in Excel?

"It can be done with a bit of trickery, but if it's a simple chart, it's almost definitely easier to just manually draw some new labels using text boxes with opaque backgrounds over the existing labels.

But...

Hide the existing Y-axis ticks and labels, then plot a new X-Y series of points like this:

x y

0 1

0 2

0 3

0 4

. .

By changing the format of the point markers to something suitable, like horizontal lines,you'll get a new set of tickmarks straight up the y-axis.

Unfortunately this is where it gets a little more fiddly. You now need to plot a data label for each point to form your new y-axis tick labels. As far as I know not even the latest version of Excel can do this automatically, but you'll find various macros to do this for you (Google: Excel X-Y scatter point labeller).

You'll then be able to add an extra column:

x y label

0 1 f

0 2 e

0 3 d

0 4 c

. . .

Run the macro and each pseudo-tickmark will have a label next to it. But you'll need to play with label alignment settings to get them in the right place."

"Click on the chart you've created.

Under Chart Tools, click the Design tab.

Click Select Data.

In the Select Data Source window that pops up, you should see two main boxes: Legend Entries (Series) and Horizontal (Category) Axis Labels.

Under Legend Entries (Series), click the Add button.

In ""Series name,"" you can type in whatever you want to name it as text. In ""Series values,"" you enter the value that your text will represent. For example, you can rate your students' papers as Excellent, Good, Needs Improvement, or Unsatisfactory. You could enter ""Excellent"" as your first series name with the series value being ={4}. Thus, Unsatisfactory as a series name would correspond to the series value of ={1}. Click OK, and add as many Legend Entries / Series as you wish.

In the Horizontal (Category) Axis Labels field, I'm assuming all of your students names or IDs will go here. Then, when you are finished and click OK, your chart will show the students' names or IDs along the x-axis. The bars will be color coded according to their designation in the legend on the right.

This is not a perfect solution by any means. But it should give you the ability to take this chart into PowerPivot if you want to add slicers and get really nifty (whereas putting an opaque box over each numerical label would not allow you to convert the data to a PivotChart as nicely).

Best of luck. If anyone finds a better alternative, please post."