+ Reply to Thread
Results 1 to 3 of 3

Equal sized sections on 100% stacked cone pivot chart

  1. #1
    Registered User
    Join Date
    05-01-2014
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    5

    Equal sized sections on 100% stacked cone pivot chart

    Hello, I've created a 100% stacked cone pivot chart as shown in this image: http://imgur.com/weqziE2

    Is there any way to make each of the sections an equal height? A few of the filters in the accompanying pivot table mean the placements field at the bottom of the cone is very small - I'd prefer each of the sections to be the same height and let the data labels explain.

    Any advice would be really appreciated.

    Thank you,

    Matt

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Equal sized sections on 100% stacked cone pivot chart

    The pivot chart will reflect the information in the pivot table.

    You could do it with a standard chart, using 1's for each data series. The data label information could be extracted from the pivot table via formula
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    05-01-2014
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Equal sized sections on 100% stacked cone pivot chart

    Thanks Andy, will give that a try.

    Cheers!

    Matt

+ 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 Stacked Data
    By lpc87 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 12-02-2013, 08:07 PM
  2. How to add target line to stacked column pivot chart chart
    By oleg mirzaev in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 11-04-2013, 07:46 AM
  3. Stacked Bar Chart where Sum of Parts Does Not Equal the Whole
    By mcrxb in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-27-2013, 04:54 AM
  4. Pivot Chart and stacked bar graph
    By Paul-NYS in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-04-2013, 06:45 PM
  5. stacked column pivot chart
    By EnergyEngineer in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 09-11-2007, 04:51 PM

Tags for this Thread

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