Results 1 to 2 of 2

Create 100% stacked bar chart based on date and multiple variables in single column

Threaded View

  1. #1
    Registered User
    Join Date
    03-06-2013
    Location
    NYC
    MS-Off Ver
    Excel 2010
    Posts
    15

    Create 100% stacked bar chart based on date and multiple variables in single column

    Hello! I am running into difficulties creating a 100% stacked bar chart with my dataset. I know how to create the chart if I manipulate the data using a pivot table, but ideally I would be able to create the same stacked bar chart using my original data export.

    Dataset (3 columns)

    Date Variable Value
    October X 100
    October Y 200
    October Z 150
    November X 150
    November Y 205

    I want the x-axis to be the month and the bars to show the % of month total for that variable. Is it possible to get this stacked bar chart without manipulating the data into a pivotable with variables in the column and dates in the top row?

    Let me know if need any clarification. I have attached a sample spreadsheet showing how my data exists, and the end chart I would like to get from it.
    Attached Files Attached Files
    Last edited by mattadler22; 11-29-2017 at 04:07 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] How to create a 3D stacked column chart
    By JimDandy in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-23-2017, 01:41 PM
  2. Combining a Column histogram with a stacked column in a single chart
    By Mythicos in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-25-2016, 12:40 PM
  3. Replies: 1
    Last Post: 06-17-2015, 09:31 AM
  4. How to create a stacked column chart
    By john9210 in forum Excel General
    Replies: 1
    Last Post: 10-19-2009, 05:01 AM
  5. How to create a simple Stacked Column chart?
    By Mike in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-17-2006, 09:35 AM
  6. How do I create a chart that uses both columns and stacked column.
    By buske in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-25-2006, 12:10 PM
  7. To create a stacked column chart and group the stacked bars togeth
    By Jacqueline in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-18-2005, 10:06 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