Bar Chart with Data Elements

F

Fly32

Hi,

I am trying to create a Bar Chart with each data element listed in th
bar itself. For example, the sheet has:

Team, Name
Red, LIAM
Yellow, CHARLOTTE
Red, NOAH
Green, AMELIA
Blue, OLIVER
Red, OLIVIA
Yellow, AIDAN

I want a bar chart by team color, then each bar to contain the names o
each person, as per below chart. Is there a quick way of doing this?
I'm dealing with lots of rows of data so the example is rathe
simplified. Right now, I'm manually creating a pivot table, then
chart, then typing the text in; rather time consuming.

Thanks in advance

+-------------------------------------------------------------------
|Filename: Example.jpg
|Download: http://www.excelbanter.com/attachment.php?attachmentid=952
+-------------------------------------------------------------------
 

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

Bar chart problem 3
Average bar charts with individual data points 2
Plotting a 3D Bar Chart 1
Employee Schedule not plotting properly - chart type / data series not correct 0
Stacked column with additional single bar chart 2
Conditional Format Bar Chart 5
Formatting a bar chart 1
Stacking data from within a series within a bar chart 1

Top