+ Reply to Thread
Results 1 to 1 of 1

Create a multiple combination pivot chart with a tbl that has multiple formulas

  1. #1
    Registered User
    Join Date
    09-13-2012
    Location
    USA, North America
    MS-Off Ver
    Excel 2010
    Posts
    14

    Create a multiple combination pivot chart with a tbl that has multiple formulas

    The table I am using consists of many levels for instance cell D15 is the sum of cells D16:17, D17 is the sum of D18:19 and D19 is the sum of D20 (the file is attached). So basically I have several summary tabs, but I am wondering is there a way to create a table that does this automatically? More specifically can I assign a summary row and it automatically knows the cells following add up to that particular row based on the text being tabbed over or any other criteria (similar to Microsoft Project)? If this is possible, can I create a multiple combination pivot chart to reflect this information? I want a pivot chart that reflects the total dollar amount AND the percentage of the total dollar amount provided. I haven't added the percentages in the file I attached; however, each column with a dollar value will have a column next to it reflecting the percentage of the total (I also have not included a total column). I want a line and bar graph combination. Thanks in advance
    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