+ Reply to Thread
Results 1 to 10 of 10

Trying to only compare one bar in a bar chart that has multiple months

  1. #1
    Registered User
    Join Date
    10-22-2013
    Location
    Victoria, TX
    MS-Off Ver
    Excel 2010
    Posts
    28

    Trying to only compare one bar in a bar chart that has multiple months

    I have a bar chart that lists months and shows the percentage. I would like to compare the 1st quarter average from this year to last year. I do not want to compare the months individually, just the 1st quarter. Does that make sense? I have attached a picture where I have what I want to do separated into 2 charts. I want to take the bars from the 2nd chart and add it to the first without comparing anything to Jan, Feb, or March. Any help?
    excel chart.png

  2. #2
    Forum Expert
    Join Date
    09-20-2011
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    2,278

    Re: Trying to only compare one bar in a bar chart that has multiple months

    Hello
    Something like this?

    Chart Example.jpg

  3. #3
    Registered User
    Join Date
    10-22-2013
    Location
    Victoria, TX
    MS-Off Ver
    Excel 2010
    Posts
    28

    Re: Trying to only compare one bar in a bar chart that has multiple months

    Close. But is there any way to add Qtr 15 and Qtr 14 to the end? So it has Jan, Feb, Mar, and the Qtr15 and Qtr14 right next to each other?

    Thanks for helping!

  4. #4
    Forum Expert
    Join Date
    09-20-2011
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    2,278

    Re: Trying to only compare one bar in a bar chart that has multiple months

    I'll work on it and get back if I come up with a solution.

  5. #5
    Forum Expert
    Join Date
    09-20-2011
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    2,278

    Re: Trying to only compare one bar in a bar chart that has multiple months

    Is this closer?

    Chart Example 2.jpg

  6. #6
    Registered User
    Join Date
    10-22-2013
    Location
    Victoria, TX
    MS-Off Ver
    Excel 2010
    Posts
    28

    Re: Trying to only compare one bar in a bar chart that has multiple months

    That is perfect!!!!!

    How did you do that?

  7. #7
    Forum Expert
    Join Date
    09-20-2011
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    2,278

    Re: Trying to only compare one bar in a bar chart that has multiple months

    Hello
    I've put a message in your other post which is a duplicate to this one. I'll upload a sample file and explain the above chart.

    Regards
    DBY

  8. #8
    Forum Expert
    Join Date
    09-20-2011
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    2,278

    Re: Trying to only compare one bar in a bar chart that has multiple months

    Hello
    Here's the example chart. You need to use the data layout with some empty spaces so as to move the Qtrs to the end of the Axis. If you didn't need them pulled together, you could put them all on one axis but as you want the Month bars spaced I've put the Qtrs and Months on different Axis and series in order to format each differently.

    DBY
    Attached Files Attached Files

  9. #9
    Registered User
    Join Date
    10-22-2013
    Location
    Victoria, TX
    MS-Off Ver
    Excel 2010
    Posts
    28

    Re: Trying to only compare one bar in a bar chart that has multiple months

    Sorry about the duplicate. The other one quit showing up in my posts and I couldn't find it posted, so I reposted it. That was my fault.

    Thank you so much for the help! I spent all day and just could not get it.

  10. #10
    Forum Expert
    Join Date
    09-20-2011
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    2,278

    Re: Trying to only compare one bar in a bar chart that has multiple months

    Glad to have helped..

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Trying to only compare one bar in a bar chart that has multiple months
    By BrookieOU in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-10-2015, 07:38 AM
  2. compare two actual months
    By Anto_BT in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-02-2015, 09:29 AM
  3. Compare latest 2 months of data
    By EricBarnes88 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-07-2014, 10:09 PM
  4. Replies: 2
    Last Post: 08-05-2010, 11:40 AM
  5. How can I create a chart to compare multiple data series?
    By magnoliak77 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-01-2006, 09:10 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1