Excel Bar/Column Chart y-axis label help 1

[starbird2273]

Hi, I have a column chart that is tracking the number of boxtops by teacher for my daughters school. Everything on the chart is just as I would like it to be EXCEPT the legend/label on the Y Axis

Simple Table layout is:
Teacher1 #boxtopsYTD
Teacher2 #boxtopsYTD
...
Teacher20 #boxtopsYTD

The number of boxtops is up the X axis, and each bar/column represents a different Teacher. Above the bar is the value/count of boxtops. Then I have a legend that shows Teacher1 is red, Teacher2 is orange, etc.

What I would rather have is the Teacher name under the corresponding bar, and eliminate the legend. Can this be done? If it matters, I am in Excel 2008 for Mac, but couldn't format it in 2003 for windows, either.

 

[JPaules]

It can be done. I assume your table is set up like you show? I just laid a quick table out like that, created a column chart and that's what I got. I'm using Excel 2007 so my steps are different from 2003 but it can be done there too. Different color columns and all.

Do you have your teachers in the left column and boxtops in the right?


--
JP

 

[starbird2273]

Yes, that is how it is set up (Although not sure if this makes a difference, I am using Column A (Teachers) and Column L (Total). Each Month is in between.

That is exactly how I'd like my chart to look. How did you do it?

 

[starbird2273]

Actually, I got it to work. I basically started over with a new chart and it took care of it. Very odd it didn't the first time. Unless, of course, I made a change. Thanks for your help!

 

[JPaules]

Shouldn't make a difference at all. I'm using Excel 2007 so all I did was to populate the two columns, selected the data, and insert column chart. I did have to tell it to format the series with different colors and deleted the legend.

Excel 2007 makes it easier but IIRC, you might have to select the data series and tell it columns. I've never used Office for Macs so I can't help you there.

Are you selecting just the two columns or everything in between as well?

--
JP

 

[JPaules]

Also, try right-clicking one of the columns. Do you have any options about formating the data points? You want to add series names and data point values.

--
JP