Bar Chart with Data Elements
1 Attachment(s)
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. |
Bar Chart with Data Elements
Get the Chart Labeller addin
|
All times are GMT +1. The time now is 06:56 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com