+ Reply to Thread
Results 1 to 2 of 2

Combining a bar graph with a stacked graph.

  1. #1
    Registered User
    Join Date
    09-20-2018
    Location
    North Carolina
    MS-Off Ver
    2010
    Posts
    1

    Combining a bar graph with a stacked graph.

    Hello,

    I'm currently trying to plot a graph that shows two sets of data per day of the week:
    -Orders
    -Total units (with direct orders and fulfilled orders stacked on top of each other).

    If you refer to the attachment provided, this is the furthest I've gotten by searching forums, but there's a couple more things I would like to do:
    -Have the days of the week centered under the two sets of bars that represent each day, and
    -Move the two sets of bars on each day closer to each other, without the stacked bars separating from one another.

    Any help appreciated. Thanks!
    Attached Images Attached Images

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

    Re: Combining a bar graph with a stacked graph.

    I think this "clustered and stacked" column chart tutorial will show what you want: https://peltiertech.com/clustered-st...mn-bar-charts/ Note the blank row he puts in the data table to provide the gap between days. He also uses a "dummy" series to create the axis labels centered underneath each cluster.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ 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. Combine Line Graph & Stacked Column Graph
    By CGreenie in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-07-2015, 12:09 PM
  2. Combining Stacked Bar Graph with Scatter Graph
    By cunningj in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-08-2014, 04:29 AM
  3. Combining a bar graph and line graph with 2 sets of data
    By lynzlou in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 06-11-2014, 12:49 AM
  4. [SOLVED] Plotting a standard bar graph on the same axes as a stacked bar graph
    By Shearwater in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 05-01-2014, 04:59 AM
  5. [SOLVED] 3 axis chart with stacked bar graph and line graph above
    By hefe_espada in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-26-2013, 12:53 PM
  6. Creating a graph similar to a stacked column graph
    By Jonathan in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 08-04-2006, 11:30 AM
  7. Can I create graph combining clusted and stacked columns?
    By Robin in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-19-2006, 11:35 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