+ Reply to Thread
Results 1 to 3 of 3

Stacked chart with 3 data sets (variables)

Hybrid View

  1. #1
    Registered User
    Join Date
    03-23-2015
    Location
    toronto
    MS-Off Ver
    2010
    Posts
    52

    Stacked chart with 3 data sets (variables)

    How do I create a stacked chart with 3 variables?

    What I have is ex: duration to make a pizza.

    I have 4 months that i need to be displayed in one long chart.

    Vertical Info: Time from phone call to chef, chef to topings, topics to oven, oven to delivery.
    Horizontal Info: Store 1, store 2, store 3, store 4, store 5.

    So what i need is a stacked chart that shows the data for each month.. so have 5 bars close to each other for the AUG, 5 bars close to each other for JULY and so on.. with dates Y axis and months as X axis.

    Help please!

    Thanks

  2. #2
    Registered User
    Join Date
    03-23-2015
    Location
    toronto
    MS-Off Ver
    2010
    Posts
    52

    Re: Stacked chart with 3 data sets (variables)

    anyone????

  3. #3
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP, 2007, 2024
    Posts
    16,529

    Re: Stacked chart with 3 data sets (variables)

    If I understand what you are saying (which might be difficult with so many different variables), it sounds like you want a clustered and stacked column chart. I would suggest that you start with this tutorial. http://peltiertech.com/clustered-sta...mn-bar-charts/
    Pay careful attention to the way that he arranges the data in the spreadsheet for this chart. If you get the data arranged properly in the spreadsheet, then creating the chart is relatively easy.

    This will probably not be the final solution to your problem, but it should give you a good start. I would suggest that you try the clustered and stacked column for one data set for each of the 5 stores. After you get it working for one data set, then we can work on extending it for several months.
    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. Replies: 2
    Last Post: 05-21-2014, 09:32 AM
  2. Replies: 1
    Last Post: 05-30-2013, 10:03 AM
  3. [SOLVED] Help to Chart Comparison Data of 2 sets of data with 5 variables each needed please
    By bluejasmine in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 05-13-2012, 12:45 PM
  4. Count different sets of data with multiple variables
    By ransome in forum Excel General
    Replies: 2
    Last Post: 05-17-2010, 09:28 PM
  5. Plot 3 sets of data in scatter chart and area chart in one
    By geoffs52 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 12-24-2009, 04:42 AM
  6. reconcile 2 data sets with multiple variables
    By Brigitte in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-07-2007, 04:53 PM
  7. How do I group multiple sets of data for stacked bar chart?
    By Najam in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-30-2005, 12:05 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