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?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. us Eyring

    resizing if chart elements when printed

    us Eyring, Feb 3, 2004, in forum: Excel Charting
    Replies:
    0
    Views:
    97
    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:
    149
    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:
    135
    Jon Peltier
    Oct 13, 2004
  4. SMAAngel
    Replies:
    4
    Views:
    797
    MJSlattery
    Nov 5, 2004
  5. KR
    Replies:
    1
    Views:
    149
    Debra Dalgleish
    Jul 12, 2006
  6. DQuint
    Replies:
    2
    Views:
    228
    DQuint
    Sep 7, 2006
  7. Marshall
    Replies:
    3
    Views:
    268
    Jon Peltier
    Jun 19, 2007
  8. Confused One
    Replies:
    1
    Views:
    198
    Andy Pope
    Aug 14, 2008
Loading...