+ Reply to Thread
Results 1 to 2 of 2

2 Line Graphs from different years on one chart?

  1. #1
    Forum Contributor
    Join Date
    12-29-2012
    Location
    usa
    MS-Off Ver
    Excel 2016
    Posts
    325

    2 Line Graphs from different years on one chart?

    I may be overthinking this but here is my issue:

    I have one pivot table that has data from 2016 (Actuals) and another pivot table that has data from 2017 (forecast). The data is broken down by month so Jan 2016, Feb 2016, Jan 2017, Feb 2017. When I combine these two pivot tables into a line graph, excel obviously has all the actual data on the left in the 2016 range and the forecast data on the right in the 2017 range.

    How can I have excel ignore the year and have a comparison of these two line graphs over top of each other by month?

    Would I use power pivot to do so?

    Thanks.

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,920

    Re: 2 Line Graphs from different years on one chart?

    This could probably be accomplished by overlaying the pivot table results with named dynamic ranges and plotting those. Without a sample workbook, I can say no more. However, the following two articles should give you the information you need to do this:

    http://www.utteraccess.com/wiki/inde...Dynamic_Ranges

    http://www.utteraccess.com/wiki/inde...namic_Charting
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

+ 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. Replies: 4
    Last Post: 07-06-2015, 05:56 PM
  2. line chart with different years
    By ammartino44 in forum Excel General
    Replies: 8
    Last Post: 06-24-2015, 05:20 PM
  3. Replies: 3
    Last Post: 11-15-2013, 06:28 PM
  4. Replies: 2
    Last Post: 10-16-2012, 11:40 AM
  5. Add line separator between years in chart
    By maacmaac in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-03-2010, 11:36 AM
  6. Replies: 1
    Last Post: 12-05-2005, 08:35 AM
  7. Replies: 2
    Last Post: 08-12-2005, 08:05 AM

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