ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Bar Chart with Data Elements (https://www.excelbanter.com/charts-charting-excel/449936-bar-chart-data-elements.html)

Fly32 March 19th 14 06:34 PM

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.

[email protected] April 18th 14 03:59 AM

Bar Chart with Data Elements
 
Get the Chart Labeller addin



All times are GMT +1. The time now is 04:38 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
ExcelBanter.com