Bar Chart with Data Elements
Hi,
I am trying to create a Bar Chart with each data element listed in the 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 of 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 rather simplified. Right now, I'm manually creating a pivot table, then a chart, then typing the text in; rather time consuming.
Thanks in advance.
|