+ Reply to Thread
Results 1 to 4 of 4

Need help about pivot table and pivot chart !!!

Hybrid View

  1. #1
    Registered User
    Join Date
    03-30-2010
    Location
    Vietnam
    MS-Off Ver
    Excel 2007
    Posts
    8

    Need help about pivot table and pivot chart !!!

    In my Excel file, sheet pivot.

    How can i show only the Duration and Amount Granted per year, i dont want to SUM those figures because of no meaning when sum those figures.

    Also i want to insert 1 new column "Total Amount Granted". This column's value is (Duration *Amount Granted per year). And i want to sum this column.

    Finally, how can i do the chart which show ONLY "Total Amount Granted" (not Duration and Amount Granted per year).

    I hope someone can tell me the way to do, because i need to understand the strategy.
    Thank you very much. I really need the answer
    Attached Files Attached Files
    Last edited by ptx1987; 03-31-2010 at 02:11 AM.

  2. #2
    Registered User
    Join Date
    03-30-2010
    Location
    Vietnam
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Need help about pivot table and pivot chart !!!

    Can some one help me (

  3. #3
    Registered User
    Join Date
    03-30-2010
    Location
    Vietnam
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Need help about pivot table and pivot chart !!!

    Please help me. I really need the solution.

  4. #4
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326

    Re: Need help about pivot table and pivot chart !!!

    Please allow people some time before " bumping". We usually ask to wait 24 hrs ( see forum rules) before sending a follow up request

    Attached is a possible solution with XL2003 ( no chart added)
    Is this what you need?
    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