Hi. I have a Pivot Table which shows the number of outstanding items by category. I would like to add a column to the Pivot Table which shows the KPI measurement for each category. Then I would like to graph this using combination bar/line graph. I cannot get the graph to recognise the column I am adding next to the Pivot Data. Thank you.
Last edited by Jen MMM; 01-09-2012 at 11:20 PM.
Hi, is the KPi measurment a manual formula toget the results from the pivot? if so you can add the formula to a pivot table, so you can add it to your chart.
What "interested" is trying to say is that you could use Calculated Field / Calculated Value which are part of the pivot itself.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Hi,
Interested has given you one option. Another is just to add an extra field (column) to your data.
Regards
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Thank you for all your replies.
In the end I have added another column of information to my source data.
For "Interested" the KPI was just a flat number across the board. Ie Actual Items Picked vs KPI of 10 per hour. I have seen previously where you could just add the extra column after refreshing the Pivot Table. I just couldn't make it work again.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks