+ Reply to Thread
Results 1 to 2 of 2

Grouping data columns in a pivot table to create groups of stacked bars in a pivot chart

  1. #1
    Registered User
    Join Date
    07-22-2015
    Location
    Frankfurt Germany
    MS-Off Ver
    2010
    Posts
    1

    Grouping data columns in a pivot table to create groups of stacked bars in a pivot chart

    Hi,

    I am new here. I am trying to solve a problem of grouping data columns in a pivot chart to show 3-week trends (PW, LW and TW) in a pviot chart. Attached is an illustration.

    I would like to see for all months separate stacked bars. One each for PW, LW and TW.

    Any help would be appreciated.

    Thanks in advance!
    Attached Images Attached Images

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Grouping data columns in a pivot table to create groups of stacked bars in a pivot cha

    You get better help on your question if you add a small excel file, without confidential information.

    Please also add manualy the expected result in your file.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

+ 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. pivot chart with clustered stacked-columns
    By bsapaka in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-07-2020, 06:56 PM
  2. Pivot table- create to groups based on values
    By Marvin85 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-23-2015, 02:59 AM
  3. Replies: 0
    Last Post: 03-06-2014, 07:21 AM
  4. [SOLVED] using vba to create grouping in pivot table
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-14-2013, 10:51 AM
  5. [SOLVED] How to create groups in pivot table drop down list
    By garciae2 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 04-08-2013, 10:42 AM
  6. [SOLVED] Grouping data in pivot table columns
    By ConnieMS in forum Excel General
    Replies: 4
    Last Post: 07-17-2006, 12:20 PM
  7. [SOLVED] 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