+ Reply to Thread
Results 1 to 3 of 3

Overlay two years in bar chart

  1. #1
    Registered User
    Join Date
    02-06-2012
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2010
    Posts
    23

    Post Overlay two years in bar chart

    Hello fellow excel users again,

    I have a long dataset with many hundreds of dates in one column for a databse. It is used to see if we are sending and receiving more packages on a year by year basis.

    What i would like is a visual representation of this data which I can do quite easily in a bar graph whcih splits it into months and years. What i don't know how to do easily is overlay or overlap the two years of data in the one bar graph for the same month.

    Essentailly what i want is a bar graph from Jan to December month by month. Then red bars (can be any colour) for 2011 number of received packages in a given month and blue overlapped or adjacent to it in same month of chart for the 2012 received number of packages.

    I know how to do this when I have two seperate columns of data for different years. But can't figure it out when two different years are in the same column.

    UPDATE: Essentially I want to have something like this for the 2011 and 2012 year with two different coloured bars to distinguish the different years for each each month. But don't know how to do it when the date for 2011 and the data thus far for 2012 comes from the same column :-S
    Last edited by jimmyqwerty; 02-07-2012 at 01:38 AM.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,882

    Re: Overlay two years in bar chart

    If you go to this website and scroll down to overlapped bar charts, I think you will find what you are looking for.

    http://peltiertech.com/WordPress/example-charts/
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Expert OnErrorGoto0's Avatar
    Join Date
    12-30-2011
    Location
    I DO NOT POST HERE ANYMORE
    MS-Off Ver
    I DO NOT POST HERE ANYMORE
    Posts
    1,655

    Re: Overlay two years in bar chart

    It sounds to me as though a pivot chart would suit. Group the dates on month and year and use year as the series.
    Good luck.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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