+ Reply to Thread
Results 1 to 7 of 7

Trying to combine two graphs (year to year compare)

  1. #1
    Registered User
    Join Date
    08-16-2013
    Location
    West Coast USA
    MS-Off Ver
    Excel 2019/365
    Posts
    12

    Trying to combine two graphs (year to year compare)

    I have been searching, but can't seem to come up with what I need. It seems there must be a way since they say a picture is more descriptive... this is my representative data:sample.jpg
    I would like to merge these two charts so that all 6 lines are on the same chart and the X axis titles are Jan, Feb...

    I would like to do it without rearranging the data (altho adding additional rows is ok) because I also want a 13month graph as well (i.e. the most current 13 months) I have read about dynamic ranges and I want to do that in the future, (but I am still manually changing the range) Before I tackle that, I want to first figure out how to get year to year in the same chart.

    Here is the actual sheet
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    08-28-2013
    Location
    Phoenix, Arizona
    MS-Off Ver
    Excel 2010, 2013
    Posts
    69

    Re: Trying to combine two graphs (year to year compare)

    Quick and dirty solution is to set the backgrounds to transparent and overlay one on top of the other. Stretch them out horizontally and add ticks to the points rather than on the left side for the sales.

    The other option, is to create 3 more X Axis lines based on the previous year's data with significantly different coloring.

  3. #3
    Forum Expert cbatrody's Avatar
    Join Date
    04-15-2014
    Location
    Dubai
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    2,136

    Re: Trying to combine two graphs (year to year compare)

    Hi,

    I have updated the file with second option (3 more X Axis lines).
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    08-28-2013
    Location
    Phoenix, Arizona
    MS-Off Ver
    Excel 2010, 2013
    Posts
    69

    Re: Trying to combine two graphs (year to year compare)

    Good morning, cbatrody.

    It looks good, I would recommend making the colors more strikingly different though. Does this resolve the issue?

    Thanks!

    Jan

  5. #5
    Forum Expert cbatrody's Avatar
    Join Date
    04-15-2014
    Location
    Dubai
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    2,136

    Re: Trying to combine two graphs (year to year compare)

    Good Morning!

    Yes, I guess the lines would look more distinct if you apply striking colors on them. You can right click on individual lines and change their colors.

  6. #6
    Registered User
    Join Date
    08-16-2013
    Location
    West Coast USA
    MS-Off Ver
    Excel 2019/365
    Posts
    12

    Re: Trying to combine two graphs (year to year compare)

    Thank you. It's the next month end and I am back to revisit this I thought I would have to break the file some way between 2013/2014 but I wasn't sure how exactly to accomplish my goal.

  7. #7
    Forum Expert cbatrody's Avatar
    Join Date
    04-15-2014
    Location
    Dubai
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    2,136

    Re: Trying to combine two graphs (year to year compare)

    Do you need any help in updating the file?

+ 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. Formula to compare previous year to current year
    By bjnockle in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-08-2013, 04:23 PM
  2. Replies: 3
    Last Post: 09-04-2013, 10:49 AM
  3. Replies: 0
    Last Post: 04-18-2006, 02:10 AM
  4. How to compare current year to prior year in bar chart?
    By substring in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 05-12-2005, 02:06 PM
  5. Compare values year to year in a line graph
    By Purdue02 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-04-2005, 02:28 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