+ Reply to Thread
Results 1 to 5 of 5

How do i display multiple weeks of similar data in the same graph?

  1. #1
    Registered User
    Join Date
    12-18-2018
    Location
    Alpharetta, GA
    MS-Off Ver
    2016
    Posts
    38

    How do i display multiple weeks of similar data in the same graph?

    I am trying to do a stacked bar chart that displays multiple weeks of data in 1 view. Below is a table for the first week of data. There will be similar data for the next few weeks. I one stacked bar column i would like to display Stock Room A (high an d low with 2 colors). The 2nd bar would have the Stock Room B high and low values. How can i group them by week? If stacked bar chart is not the best option to represent this that is fine, i am open to suggestions. I know this is possible but i just cant seem to figure it out. Thanks in advanced!!!



    Stock Room A 41% (High) 59% (Low)
    Stock Room B 24% (High) 76% (Low)

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: How do i display multiple weeks of similar data in the same graph?

    Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

  3. #3
    Registered User
    Join Date
    12-18-2018
    Location
    Alpharetta, GA
    MS-Off Ver
    2016
    Posts
    38

    Re: How do i display multiple weeks of similar data in the same graph?

    Thank you for the fast reply. The workbook and a mock up have been posted.
    Attached Images Attached Images
    Attached Files Attached Files

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

    Re: How do i display multiple weeks of similar data in the same graph?

    I find that a lot of charting questions are often more about the spreadsheet than the chart. In this case, I would change the way the data are arranged in the sheet, then create the chart.

    1) Your picture suggests that you want both week # and stock room # to be on the vertical category axis. That means Excel is going to want both of those "fields" in columns (or rows). My first step was to "unpivot" the table (I did it manually, but you can use Power Query/Get and Transform in your version of Excel to accomplish the same thing) so that week number was in column A, stockroom # was in column B, and the high and low values were in columns C and D.
    2) Select the new table and insert a 100% stacked bar chart. If necessary, edit the source data so that Excel is using columns A and B for the X axis data and C and D as the values.
    3) Format the chart as desired.

    I don't know if that is going to be exactly what you want, but that should come pretty close to your picture.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  5. #5
    Registered User
    Join Date
    12-18-2018
    Location
    Alpharetta, GA
    MS-Off Ver
    2016
    Posts
    38

    Re: How do i display multiple weeks of similar data in the same graph?

    This was exactly what i was looking for!!!THANK YOU SO MUCH!!!

+ 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: 02-14-2017, 09:33 AM
  2. Subtotal all data and display on bar graph
    By otsegonaut in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 06-29-2013, 07:24 PM
  3. How to setup a graph from multiple data sets into a single display
    By pjw23 in forum Excel Charting & Pivots
    Replies: 9
    Last Post: 10-20-2012, 06:03 AM
  4. Replies: 0
    Last Post: 05-30-2012, 08:27 PM
  5. Replies: 2
    Last Post: 10-17-2011, 04:45 AM
  6. Replies: 4
    Last Post: 02-13-2011, 05:37 AM
  7. [SOLVED] 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

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