Results 1 to 7 of 7

Thread: Help with chart

  1. #1
    3 Star Lounger Jimmy-W's Avatar
    Join Date
    Jan 2001
    Location
    Helena, Montana, USA
    Posts
    220
    Thanks
    13
    Thanked 0 Times in 0 Posts

    Question Help with chart

    I attached my spreadsheet, which contains numbers of fruits for each of 2013, 2014, and 2015. I'd like to create a bar chart that groups each fruit by year, with a tri-color bar, with one color for each year. For example, the year 2013 could be blue for each fruit, and "lemons" would be presented with a three-piece bar with a blue bar for 2013 and different colors for each of the other years. The fruit could be identified on the X axis and the Y axis would provide the quantity of each fruit/year. It's hard to explain, but each fruit basically would have one bar made up of three colors, one for each year. Thanks!
    Attached Files Attached Files
    JimmyW
    Helena, MT

  2. #2
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,631
    Thanks
    115
    Thanked 645 Times in 589 Posts
    Jimmy,

    Sort your data by year then fruit. Set up the chart like I have it.

    HTH,
    Maud

    Chart.png
    Attached Files Attached Files

  3. The Following User Says Thank You to Maudibe For This Useful Post:

    Jimmy-W (2015-12-07)

  4. #3
    3 Star Lounger Jimmy-W's Avatar
    Join Date
    Jan 2001
    Location
    Helena, Montana, USA
    Posts
    220
    Thanks
    13
    Thanked 0 Times in 0 Posts
    Thanks for the help, Maud! You're great! If I want to insert the quantity (number) in each bar, where is that option? In other words, the left-most blue bar (apples) would include 64. A horizontal bar chart with the numbers at the ends of the bars would work, too.
    Last edited by Jimmy-W; 2015-12-04 at 11:07.
    JimmyW
    Helena, MT

  5. #4
    New Lounger
    Join Date
    Nov 2015
    Posts
    17
    Thanks
    8
    Thanked 2 Times in 2 Posts
    Like this?
    Attached Files Attached Files

  6. The Following User Says Thank You to _Zeno_ For This Useful Post:

    Jimmy-W (2015-12-07)

  7. #5
    3 Star Lounger Jimmy-W's Avatar
    Join Date
    Jan 2001
    Location
    Helena, Montana, USA
    Posts
    220
    Thanks
    13
    Thanked 0 Times in 0 Posts
    Exactly. Thanks again!
    JimmyW
    Helena, MT

  8. #6
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,631
    Thanks
    115
    Thanked 645 Times in 589 Posts
    Jimmy,

    In case it wasn't clear how Zeno added the number, right click on a bar for each series and click Add Data Labels

    jimmy2.png

    Right clicking on the numbers will allow you to position where you want the number to be

  9. The Following User Says Thank You to Maudibe For This Useful Post:

    Jimmy-W (2015-12-07)

  10. #7
    3 Star Lounger Jimmy-W's Avatar
    Join Date
    Jan 2001
    Location
    Helena, Montana, USA
    Posts
    220
    Thanks
    13
    Thanked 0 Times in 0 Posts
    Thanks again, Maudibe! That one I actually figured out by myself.
    JimmyW
    Helena, MT

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •