Hi
Im trying to create a pie chart from a pivot table that shows the following
There are two companies SEL & TSTHS each has three workers in each. Im trying to to find out
Worker % of profit from each company total in each tax year
Worker % of profit from overall total (both companies) in each tax year
Can anyone show me how
Thanks in advance
Hi
Can anyone help with the above?
Thanks
Dave
If I understand correctly then one way would be to produce two pivot tables.
The first is populated as in the file attached to post #1 and the second (modeled on the PIVOT2 sheet) excludes 'company' from the legend field.
The data labels on each pie chart are formatted to display category name and percentage.
Use the filters at the bottom of either pie chart to display the tax year.
There is also a company filter at the bottom of the pie chart on the PIVOT sheet.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks