Stacked Bar Legend problem

  • Thread starter Thread starter Tod
  • Start date Start date
T

Tod

The table of data for my chart has names down the side
and CBT Groups across the top. The data in the middle is
number of CBTs completed by each person. Something like
this:

Name Winx OS10 MCP A+
Bill 5 0 1 0
Jim 2 1 0 0
Jane 7 0 1 0
Lacy 1 0 0 1
Marvin 3 1 1 0

I want to create a stack bar chart that has names as the
X axis. The bar for each name will have within it stacks
of CBTs they have completed. I'm able to create the chart
but I can not get the CBT Group titles to appear in the
Legend. The legend just says Series1, Series2, etc. If I
go to Source Data and type in my X axis range if just
creates extray bars. So how can I get the CBT titles in
the Legend, names across the bottom of the chart?

tod
 
Tod -

Delete the word Name from the top left cell, then select the top row before starting
the chart wizard. Plot by columns, and you should have your legend labels.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Stacked bars with textlegends in each stacked bar 7
Removing 0 in Stacked Column Chart 1
Stacked Color Charts 1
Impossible - Dynamic Legend? 5
Stacked columns width too thin - how can I alter? 1
Stack Chart Legend Display 1
How do I reverse a legend in a stacked bar chart? 1
Stacked bar and lines on 2 axes 1

Back
Top