Results 1 to 6 of 6

clustered stacked column pivot chart broken down by the data in each attribute

Threaded View

  1. #1
    Registered User
    Join Date
    07-20-2018
    Location
    Boston
    MS-Off Ver
    360
    Posts
    3

    clustered stacked column pivot chart broken down by the data in each attribute

    Hi all, I am trying to build a stacked bar pivot chart with survey data.
    The data was generated from a matrix table question in a survey where responders were evaluating 6 different attributes in 3 different levels.
    The results will look like this:

    user id Q1_Atribute1 Q1_Atribute2 Q1_Atribute3 Q1_Atribute4 Q1_Atribute5 Q1_Atribute6
    1 definitely maybe maybe maybe no way definitely
    2 maybe definitely definitely no way definitely
    3 maybe maybe maybe no way definitely
    4 definitely no way definitely maybe no way
    5 maybe maybe definitely definitely
    6 no way no way no way maybe definitely
    7 maybe no way definitely no way definitely
    8 no way maybe maybe definitely
    9 no way definitely no way no way no way definitely
    10 maybe maybe maybe no way no way definitely

    In excel i am trying to build a stacked bar column chart that will shoe the breakdown of each one of these attributes in the appropriate levels.
    I am able to chart the total responses for each attribute but then cannot break down each column by the ("definitely", "maybe", "no way") shown in different colors. I need them all i one chart so i can do filtering.
    I have attached a sample of the data.
    Thanks to anyone who can help....
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. pivot chart with clustered stacked-columns
    By bsapaka in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-07-2020, 06:56 PM
  2. Stacked clustered column chart
    By jpmoglia in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-14-2017, 09:58 PM
  3. 2-level 3-dimensional Pivot chart with stacked-clustered columns
    By Wustuv in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 11-18-2016, 04:45 AM
  4. [SOLVED] Clustered and Stacked column in the same chart
    By bryan444 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 07-16-2013, 10:03 AM
  5. Clustered and Stacked Column Chart
    By superkid in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-19-2009, 09:54 AM
  6. Combined: Clustered-Stacked Column Chart
    By cdo in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-30-2005, 09:05 PM
  7. Clustered column chart with stacked coumns
    By Dave in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-04-2005, 07:06 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