Results 1 to 5 of 5

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

Threaded View

  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

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