+ Reply to Thread
Results 1 to 2 of 2

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 BrookieOU

    This is a double post. As I've been dealing with your question here:

    http://www.excelforum.com/excel-gene...ml#post4097154

    and is breaking rule 5:

    "Don't duplicate threads. If you have posted the question in one forum, do not post it again in another forum. You are duplicating efforts. If you feel the thread is in the wrong forum and needs to be moved to another forum, PM a mod / admin to do it for you."

    I'll continue to answer you post in the other thread unless the Mods move things.

    DBY
    Last edited by DBY; 06-10-2015 at 07:42 AM.

+ 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. compare two actual months
    By Anto_BT in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-02-2015, 09:29 AM
  2. Compare latest 2 months of data
    By EricBarnes88 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-07-2014, 10:09 PM
  3. Replies: 2
    Last Post: 08-05-2010, 11:40 AM
  4. [SOLVED] 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
  5. Last 12 months chart
    By mccall213 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-29-2006, 08:50 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