Changing Y Axis to Non-numerical value for Stacked Column Chart

Hello All,

I'm having a problem. I have a stacked bar chart that has my company's web traffic for the Month of January 2013. I have the following data.

Campaigns
Organic - 7978
Referral - 5129
Direct - 2883
CPC - 2883
Email - 893

I need to know how to change the Y axis from the numerical numbers to the Titles of the campaign. I've tried using the XY Chart Labels Add-In but I'm not sure I'm using it right. I need this information like yesterday. Please help. I've attached the chart below. It's a simple chart as I've only got January's information. Thanks!

Not sure what you mean by changing the y axis ... maybe try tried this:

click the layout tab in the chart tools, select data labels > more data label options, and click 'series name'

Hi Nicky,

What I mean is where the Y axis has the numerical numbers as the vertical value, I need that value to be the series names (Organic, CPC, Direct, etc.)

I did try your suggestion but it wasn't quite what I was looking for. If you have any other suggestions please let me know. Thanks for your reply!

Hi
The y axis has to be numeric to tell the chart how large each of the stacked bars must be.
The best I can think of is to hide the numeric axis labels and add text boxes to indicate the series names

Hmmm... that might actually do the trick. Sometimes the simplest tasks seem so hard! Hopefully that will work. Thanks NickyC!