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/
_______
 
Back
Top