+ Reply to Thread
Results 1 to 3 of 3

How to present a computed column in a pivot chart?

  1. #1
    Forum Contributor
    Join Date
    12-30-2012
    Location
    Israel
    MS-Off Ver
    2007, 2016
    Posts
    642

    How to present a computed column in a pivot chart?

    Hi. I'm having problem with making the pivot chart tool to present a computed column. In the attached file I want that automatically the result of C/B would be presented in the chart. But when I try to define C as C/B it delieves N/A. Need your help. Thank you.
    Attached Files Attached Files

  2. #2
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2016
    Posts
    2,310

    Re: How to present a computed column in a pivot chart?

    Hello.....I'm not sure if you mean an actual calculated Field...the file you uploaded didn't have a Pivot Table....so I made some assumptions...see if it is what you are looking for....
    Attached Files Attached Files
    Ernest

    Please consider adding a * if I helped

    Nothing drives me crazy - I'm always close enough to walk....

  3. #3
    Forum Contributor
    Join Date
    12-30-2012
    Location
    Israel
    MS-Off Ver
    2007, 2016
    Posts
    642

    Re: How to present a computed column in a pivot chart?

    Thank you for your help. You've mentioned that my file having no pivot table in it. This is correct, as I wrote I was trying to use pivot chart rather than pivot table. Anyway, I may find a solution which evolves a "calculated field".

+ 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