+ Reply to Thread
Results 1 to 2 of 2

Excel bar graph multiple data sets

  1. #1
    Registered User
    Join Date
    04-25-2017
    Location
    Sweden
    MS-Off Ver
    Microsoft Office 365 ProPlus Version 2002
    Posts
    33

    Excel bar graph multiple data sets

    Hello,

    I've tried to make a excel file showing what I want to illustrate.

    I have three data sets: Total Sales (which includes chair sales), chair sales and competitor sales.

    I want to make a bar graph with two bars per time interval (per quarter). The first bar should only be Competitor sales by itself. The second bar should be Total sales, but which also includes chair sales, in order to show how big portion of total sales comes from chairs.

    I've only managed to create the graph either with all three data sets in three different bars or them all merged in one bar. Can someone help me with this?


    /Peter
    Attached Files Attached Files

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,472

    Re: Excel bar graph multiple data sets

    You need to modify the data layout so there is an empty row between Total and Chair.

    Create clustered column chart for all 4 series.
    Move Chair and Competitor series to secondary axis
    Delete secondary axis, so they use the same vertical scale.

    The chair series should now sit infront of Total and competitor is on it's own
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

+ 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. Multiple data sets to graph
    By RJL3313 in forum Excel General
    Replies: 1
    Last Post: 08-17-2016, 02:10 PM
  2. Multiple data sets on one scatter graph?
    By Annie JP in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 01-17-2015, 05:10 PM
  3. [SOLVED] Multiple sets of data onto one graph
    By erikw48 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 12-16-2014, 10:23 AM
  4. Replies: 0
    Last Post: 12-21-2011, 12:52 PM
  5. Line Graph: multiple lines from multiple data sets?
    By Guerodemonio in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 05-28-2011, 06:15 AM
  6. One-line graph, multiple data sets
    By wani0402 in forum Excel General
    Replies: 3
    Last Post: 11-30-2010, 04:43 PM
  7. Graph with multiple data sets
    By mtansill in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-12-2010, 04:35 PM

Tags for this Thread

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