+ Reply to Thread
Results 1 to 2 of 2

Pivot Chart,dividing a column with 4values stacked into 2 columns with 2values stack

  1. #1
    Registered User
    Join Date
    04-07-2010
    Location
    Toulouse
    MS-Off Ver
    Excel 2007
    Posts
    6

    Pivot Chart,dividing a column with 4values stacked into 2 columns with 2values stack

    Hello,

    i have an other problem about pivots chart i can't resolve by myself and would like your views about it...

    In the attached file, I have a simple data table (which does not represent the reality) and a pivot table with 4 columns representing different values.

    I created a pivot stacked column chart from the table, but I would like to rearrange the display of values.
    Currently I have for each month a stack of the 4 values, however there is only a link between the first two, and a link between the last two.
    So what I would want is for each month, 2 column with a stack of the first two, and for the second column the stack of the last two.

    Do you know if this would be possible ??

    Thanks in advance,
    Regards
    Attached Files Attached Files

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,375

    Re: Pivot Chart,dividing a column with 4values stacked into 2 columns with 2values st

    Hi,

    looks like you are after a clustered column chart. I don't know if it can be done with a pivot table at all, because you need careful re-arrangement of your data values.

    see attached.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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