+ Reply to Thread
Results 1 to 3 of 3

Pivot Table / Chart- how to group rows

  1. #1
    Registered User
    Join Date
    09-17-2019
    Location
    UK
    MS-Off Ver
    Office 365
    Posts
    15

    Pivot Table / Chart- how to group rows

    Hi there,


    Can someone tell me is it possible to group together rows (which are unrelated text) in a pivot table for a chart?

    Say I have 5 rows of names and their value. I would ideally like to create a combo chart, to show row 1 vs row 2-5

    Company> Project > resources
    Genes >Project 1 > 12
    Matts >Project 2 >3
    Raddo >Project 3 >8
    Bango >Project 4 >6
    Harmo >Project 5 >14


    If rows 2-5 could be in a stacked area or bar chart showing how each name contributes to the overall number - it would be awesome
    Last edited by Gall47; 09-18-2019 at 04:27 AM.

  2. #2
    Registered User
    Join Date
    09-17-2019
    Location
    UK
    MS-Off Ver
    Office 365
    Posts
    15

    Re: Pivot Table / Chart- how to group rows

    Can anyone help? I am really stuck on this. It keeps saying it cannot group my selected data. Is this because my source data (on another sheet) was altered using power pivot and was added to data model?
    Last edited by Gall47; 09-19-2019 at 06:00 AM.

  3. #3
    Forum Contributor noboffinme's Avatar
    Join Date
    08-29-2013
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2003/7/10/13/16/19
    Posts
    1,003

    Re: Pivot Table / Chart- how to group rows

    Hi Gall47,

    Can you post your file or a dummy example that shows the behaviour, the post isn't really clear to me without this.

    Thanks
    Remember you are unique, like everyone else

+ 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 not to show $0
    By bt123123 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-04-2018, 11:45 PM
  2. Show in a pivot chart only some sub-percentages from pivot table
    By kikonas in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-25-2016, 02:35 PM
  3. How NOT to show 0% values in Pivot chart?
    By Mirisage in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 08-20-2015, 04:48 PM
  4. Pivot Chart - Show Selected Filters
    By grey in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-05-2014, 01:22 AM
  5. Pivot chart - show only top 80%
    By c_morgan in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 11-14-2013, 04:49 PM
  6. Show only the possible values in the pivot chart filter
    By ssijbabu in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-08-2013, 02:28 PM
  7. [SOLVED] Multiple Columns in Pivot Table (but don't show in Pivot Chart)
    By Gideon1973 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 04-23-2012, 10:57 AM

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