I have a filtered table I want to perform a histogram on.
Even though the table is filtered the histogram still shows the results for all the rows.
How do I perform the histogram on only the filtered row results?
I have a filtered table I want to perform a histogram on.
Even though the table is filtered the histogram still shows the results for all the rows.
How do I perform the histogram on only the filtered row results?
Have a hidden area of your workbook that shows just the filtered results and build the histogram using that area as the source.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
how do i do this? do i need to use any formulas?
Last edited by AliGW; 03-24-2018 at 08:33 AM. Reason: Unnecessary quotation removed.
Yes, you will need formulae. Without a sample workbook, I cannot help you any further.
Please don't quote whole posts, especially when you are responding to the one immediately preceding your own - it's just clutter. It's OK to quote if you are responding to a post out of sequence, but limit quoted content to a few relevant lines that makes clear to whom and what you are responding. Thanks!
For normal conversational replies, try using the QUICK REPLY box below.
See attached file
That doesn't help. There is no indication of how you wish to filter the data.
Filter by attrition Yes or No and display a histogram of the values for EnvironmentSatisfaction 1,2,3,4
How's it going?
Please remember that those who help here do so voluntarily and of their own goodwill. This is not a paid 'service': members will help when they are ready and able to do so, and not 'on demand'. Please do not try to put pressure of time on anyone here: if you get the help you need today, that's fine, but you really should not count on it. Thanks for your understanding and patience.
From the forum rules (link in the main menu above):
- If your question has not been answered within a day, consider adding another post with any additional information you believe is relevant. If you think your post is good as is, just reply to your own thread with the words "Bump no response", which will bring it to the top of the forum.
I am rather busy at the moment - sorry. If I have time later, I will help out.
Thread closed in favour of the same query posted in commercial services.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks