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.
