Hello,
I would like to have a dynamic chart that shows the distribution of values for each row of my pivot table.
Let's say I have a source data with 3000 entreprises, their respective sector, and their respective turnover.
What I would like to see is the frequency distribution of the turnovers for the selected sector (Ideally chosen from the chart drop down list).
Thank you in advance for any help you may give me (links, direct solution..) !
PS : sorry if I make any mistakes in english
you can make a pivot graph from the pivot table data.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Hello, thank you for your reply but it didn't work for me...
It says that I can't create histogram distribution from pivot table
I finally created a new pivot table, grouped the turnovers and plotted them. For viewing the distribution in each category, I added a segment
Glad I could help.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation , to all members who helped you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks