All solutions General QuestionsPIVOT TABLE Expert Solution – General Questions on Pivot Table

Excel - General Question on Pivot Table - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I'm making a a pivot table with a chart. specifically a pie chart. I have multiple data to compile into one. The data I compiled is for retail stores. pertaining to inventory. within those stores I have reasons for adjusting the inventory. Then the cost that was adjusted. How do I get all the info in the pie. The pivot table looks good. Can't get the pie to reflect
Solved by A. Q. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
User 29/08/2018 - 01:44
I'm making a a pivot table with a chart. specifically a pie chart. I have multiple data to compile into one. The data I compiled is for retail stores. pertaining to inventory. within those stores I have reasons for adjusting the inventory. Then the cost that was adjusted. How do I get all the info in the pie. The pivot table looks good. Can't get the pie to reflect
Excelchat Expert 29/08/2018 - 01:44
Hi
Excelchat Expert 29/08/2018 - 01:44
Welcome to Got it Pro
User 29/08/2018 - 01:45
i'm trying to upload my file
[Uploaded an Excel file]
User 29/08/2018 - 01:46
hi
User 29/08/2018 - 01:46
did you get file
Excelchat Expert 29/08/2018 - 01:46
Yes i did get the file
Excelchat Expert 29/08/2018 - 01:46
Trying to understand the requirement
User 29/08/2018 - 01:46
So date i need looked at is Sheet 5
Excelchat Expert 29/08/2018 - 01:46
I am looking at sheet 5
Excelchat Expert 29/08/2018 - 01:46
Yes
User 29/08/2018 - 01:47
This has the info is test222 to compile that into the pivot tabel and pie chart
User 29/08/2018 - 01:47
I need the reasons and the department to show
User 29/08/2018 - 01:47
especially on the data labels
User 29/08/2018 - 01:48
The reasons in the legend is great. But How do I get each store to show on the pie chart with the data labels of the departments
Excelchat Expert 29/08/2018 - 01:49
ok let me see
Excelchat Expert 29/08/2018 - 01:52
The pivot chart is used when you have different categories and then you want to show % of each
User 29/08/2018 - 01:52
Percent or Dollar amount total.
Excelchat Expert 29/08/2018 - 01:52
It just has some categories on one axis and values on other
Excelchat Expert 29/08/2018 - 01:52
What you have in you data is two dimentional thing
User 29/08/2018 - 01:53
So we have different departments in our store, ammo, archery clothing etc. We make adjustments on the inventory and based on the reasons in the legend.
User 29/08/2018 - 01:53
ok so how do i fix
Excelchat Expert 29/08/2018 - 01:53
Pie chart is not the right way to represent this
Excelchat Expert 29/08/2018 - 01:53
Did you try some other charts?
User 29/08/2018 - 01:54
so what would you sugges
User 29/08/2018 - 01:54
suggest
User 29/08/2018 - 01:54
no.
User 29/08/2018 - 01:54
I'm trying to simplify for store managers
User 29/08/2018 - 01:54
easy to read
Excelchat Expert 29/08/2018 - 01:54
ok let me send you the file with graph
User 29/08/2018 - 01:54
ok
User 29/08/2018 - 01:55
aventura7i40@yahoo.com is email
Excelchat Expert 29/08/2018 - 01:55
We are not allowed to communicate over emails
Excelchat Expert 29/08/2018 - 01:55
It is against the policy
User 29/08/2018 - 01:55
so how do you send
Excelchat Expert 29/08/2018 - 01:55
Hope you understand
Excelchat Expert 29/08/2018 - 01:55
I will send here only
User 29/08/2018 - 01:55
that's fine
User 29/08/2018 - 01:56
do I extract the data file on here
User 29/08/2018 - 01:56
i'm open for any help. we aren't a big company but we are large enough for growth and I can do excel just not this
Excelchat Expert 29/08/2018 - 01:58
This is the file
[Uploaded an Excel file]
Excelchat Expert 29/08/2018 - 01:58
I just paste the value on the side and made the graph
Excelchat Expert 29/08/2018 - 01:58
Have a look
Excelchat Expert 29/08/2018 - 01:58
When you hover on the graph you will know what it is representing
Excelchat Expert 29/08/2018 - 01:58
Let me know if that helps
Excelchat Expert 29/08/2018 - 02:02
Did you see?
Excelchat Expert 29/08/2018 - 02:02
Please let me know
Excelchat Expert 29/08/2018 - 02:03
Are you there?
Excelchat Expert 29/08/2018 - 02:03
Please do give good rating and reviews
Excelchat Expert 29/08/2018 - 02:03
It really helps
Excelchat Expert 29/08/2018 - 02:03
Session is about to end
Excelchat Expert 29/08/2018 - 02:03
Please tell

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc