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

  2. Fly32

    Guest

    Get the Chart Labeller addin
     
    , Apr 18, 2014
    #2
    1. Advertisements

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.
Similar Threads
  1. us Eyring

    resizing if chart elements when printed

    us Eyring, Feb 3, 2004, in forum: Excel Charting
    Replies:
    0
    Views:
    114
    us Eyring
    Feb 3, 2004
  2. cdborg - ExcelForums.com

    Bar Chart Question Multiple Elements

    cdborg - ExcelForums.com, Oct 7, 2004, in forum: Excel Charting
    Replies:
    2
    Views:
    171
    Jon Peltier
    Oct 8, 2004
  3. cdborg - ExcelForums.com

    Excel Bar Chart with many elements Example

    cdborg - ExcelForums.com, Oct 12, 2004, in forum: Excel Charting
    Replies:
    1
    Views:
    170
    Jon Peltier
    Oct 13, 2004
  4. SMAAngel
    Replies:
    4
    Views:
    824
    MJSlattery
    Nov 5, 2004
  5. KR
    Replies:
    1
    Views:
    170
    Debra Dalgleish
    Jul 12, 2006
  6. DQuint
    Replies:
    2
    Views:
    253
    DQuint
    Sep 7, 2006
  7. Marshall
    Replies:
    3
    Views:
    298
    Jon Peltier
    Jun 19, 2007
  8. Confused One
    Replies:
    1
    Views:
    227
    Andy Pope
    Aug 14, 2008
Loading...