+ Reply to Thread
Results 1 to 2 of 2

How to have a Stked Clmn Pivt Chart show one data set as a %, and the second as a whle #

  1. #1
    Registered User
    Join Date
    11-20-2013
    Location
    Dallas, Texas
    MS-Off Ver
    Excel 2010
    Posts
    1

    How to have a Stked Clmn Pivt Chart show one data set as a %, and the second as a whle #

    Hello,
    Excel help.png
    I have a stacked column pivot chart with two data sets. I need the first data set to display as a whole number, while the second data set shows as a percentage of the first data set. Please let me know if any other information is needed. I have added an attachment as well.

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

    Re: How to have a Stked Clmn Pivt Chart show one data set as a %, and the second as a whle

    You can use a calculated field.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

+ 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. Pivt table stacked bar chart
    By reneeh63 in forum Excel General
    Replies: 1
    Last Post: 08-15-2011, 08:57 PM
  2. Replies: 2
    Last Post: 02-25-2011, 04:11 PM
  3. Conditional Formatting comparing 2 clmns - one is deleted, setting new refernce clmn
    By kyrgyzstanart in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-16-2008, 07:04 AM
  4. [SOLVED] Data does not show on a chart
    By Cherisse in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-24-2006, 04:50 PM
  5. find last row and select whle row for format
    By saziz in forum Excel General
    Replies: 2
    Last Post: 02-01-2006, 08:29 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