+ Reply to Thread
Results 1 to 3 of 3

Cannot figure out how to create bar chart with line overlay using 3 variables

  1. #1
    Registered User
    Join Date
    01-07-2013
    Location
    Charlotte, NC
    MS-Off Ver
    Excel 2010
    Posts
    10

    Cannot figure out how to create bar chart with line overlay using 3 variables

    I have volume numbers for certain pack sizes (7 different packs) by month for 2018 and for 2019 (projections).

    I'm trying to create a chart that shows 2018 volume with 2019 Projection as a line chart. I'd like the ability to filter by each pack size and have that chart update - i've unsuccessfully tried many things. (excel n00b)

    Attached is the data. Any help would be greatly APPRECIATED!
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,829

    Re: Cannot figure out how to create bar chart with line overlay using 3 variables

    Your sample did not include any of your attempts, so I don't know what you tried. Here's what I did.

    1) In order to have both years filter together, I moved the 2018 data from below the 2019 table up to the right of the 2019 table (columns O:AB)
    2) I selected the 2018 data and inserted a clustered column chart.
    3) I added each of the 2019 rows as an additional data series, then changed the chart type of that series to line.
    At this point, I have a messy chart with 2018 data as columns and the 2019 data as lines. In order to filter the data, I checked the "hidden and empty cell" setting (in the Select data dialog) to make sure it was set to the default "do not show data in hidden cells", then I set up an autofilter on the overall table. https://www.wikihow.com/Use-AutoFilter-in-MS-Excel With the autofilter in place, I select the dropdown next to above pack size and select the pack size(s) I want to see in the chart.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Valued Forum Contributor
    Join Date
    09-25-2015
    Location
    Nowy Tomysl, Poland
    MS-Off Ver
    2019, O365
    Posts
    398

    Re: Cannot figure out how to create bar chart with line overlay using 3 variables

    Hello,
    As you change the data layout a little will be easier.
    In the attachment you have a comparison system for the Pack. The graph is based on a pivot table (source - data)
    Attached Files Attached Files

+ 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. [SOLVED] how to overlay line graph over a bar chart
    By jmosso in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-07-2016, 04:29 PM
  2. Replies: 2
    Last Post: 04-27-2015, 12:22 PM
  3. [SOLVED] I cant figure out how to fix my line chart
    By A10ECGENT in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 09-04-2014, 11:10 AM
  4. How overlay 5 hours of bar chart data onto 24 hours of line chart data
    By oldtauntonian in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 04-15-2013, 05:21 AM
  5. [SOLVED] Overlay Line Chart onto a Stacked Bar Chart
    By samuelll101 in forum Excel General
    Replies: 4
    Last Post: 11-22-2012, 10:26 AM
  6. How to create a vertical reference line on a time series line chart
    By Bladebgii in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-23-2012, 10:17 AM
  7. Need help on Line Chart with Multiple Variables
    By aliwaii in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-30-2011, 04:34 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