Bar Chart with Data Elements

Discussion in 'Excel Charting' started by Fly32, Mar 19, 2014.

  1. Fly32

    Fly32 Guest

    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
    +-------------------------------------------------------------------
     
    Fly32, Mar 19, 2014
    #1
    1. Advertisements

  2. Fly32

    Guest

    Get the Chart Labeller addin
     
    , Apr 18, 2014
    #2
    1. 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 (here). After that, you can post your question and our members will help you out.