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
+-------------------------------------------------------------------
 
Ad

Advertisements


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

Top