+ Reply to Thread
Results 1 to 5 of 5

Combining a bar graph and line graph with 2 sets of data

  1. #1
    Registered User
    Join Date
    03-26-2014
    Location
    Calgary, AB
    MS-Off Ver
    Excel 2007
    Posts
    11

    Combining a bar graph and line graph with 2 sets of data

    I'm sure this is an easy fix, but maybe my head cold is affecting my brain or something cause I can not figure it out! My boss wants a graph that shows:
    1 - how much steel we purchased each month from each of our supplies (3 different ones) in a bar graph
    2 - the average cost of steel purchased from each supplier each month in a line graph within the bar graph

    is that possible? I attached the worksheet that I put 3 months worth of data into, trying to figure this out!

    anyone have step by step instructions for excel 2013?
    Attached Files Attached Files

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

    Re: Combining a bar graph and line graph with 2 sets of data

    See if this helps: http://office.microsoft.com/en-us/ex...789.aspx?CTT=1
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

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

    Re: Combining a bar graph and line graph with 2 sets of data

    Hi,

    Where do you have the average cost of steel purchased in the file attached?

  4. #4
    Registered User
    Join Date
    03-26-2014
    Location
    Calgary, AB
    MS-Off Ver
    Excel 2007
    Posts
    11

    Re: Combining a bar graph and line graph with 2 sets of data

    cbatrody - if you look under Arcelor, for example, it's just at the bottom of each "cluster" ie: all the Jan PO's are listed then there is a line with price and total qty if that makes sense

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

    Re: Combining a bar graph and line graph with 2 sets of data

    Something like this?
    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. Column/line graph combination with multiple data sets
    By LukeD in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-24-2013, 05:44 AM
  2. Excel 2007 : How do I put 4 data sets onto one line style graph?
    By portisheadradio in forum Excel General
    Replies: 2
    Last Post: 12-27-2011, 12:12 PM
  3. One-line graph, multiple data sets
    By wani0402 in forum Excel General
    Replies: 3
    Last Post: 11-30-2010, 04:43 PM
  4. Replies: 1
    Last Post: 12-16-2008, 08:44 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