Closed Thread
Results 1 to 10 of 10

Histogram on filtered table, results only on filtered rows

  1. #1
    Registered User
    Join Date
    03-20-2018
    Location
    Singapore
    MS-Off Ver
    Office 365 Excel 2016
    Posts
    68

    Histogram on filtered table, results only on filtered rows

    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?

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,410

    Re: Histogram on filtered table, results only on filtered rows

    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.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    03-20-2018
    Location
    Singapore
    MS-Off Ver
    Office 365 Excel 2016
    Posts
    68

    Re: Histogram on filtered table, results only on filtered rows

    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.

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,410

    Re: Histogram on filtered table, results only on filtered rows

    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.

  5. #5
    Registered User
    Join Date
    03-20-2018
    Location
    Singapore
    MS-Off Ver
    Office 365 Excel 2016
    Posts
    68

    Re: Histogram on filtered table, results only on filtered rows

    See attached file
    Attached Files Attached Files

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,410

    Re: Histogram on filtered table, results only on filtered rows

    That doesn't help. There is no indication of how you wish to filter the data.

  7. #7
    Registered User
    Join Date
    03-20-2018
    Location
    Singapore
    MS-Off Ver
    Office 365 Excel 2016
    Posts
    68

    Re: Histogram on filtered table, results only on filtered rows

    Filter by attrition Yes or No and display a histogram of the values for EnvironmentSatisfaction 1,2,3,4

  8. #8
    Registered User
    Join Date
    03-20-2018
    Location
    Singapore
    MS-Off Ver
    Office 365 Excel 2016
    Posts
    68

    Re: Histogram on filtered table, results only on filtered rows

    How's it going?

  9. #9
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,410

    Re: Histogram on filtered table, results only on filtered rows

    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.

  10. #10
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,410

    Re: Histogram on filtered table, results only on filtered rows

    Thread closed in favour of the same query posted in commercial services.

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 3
    Last Post: 05-07-2017, 02:53 PM
  2. How to Reduce Filtered Results in Pivot Table?
    By clayjm in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-19-2015, 04:42 PM
  3. [SOLVED] Put Borders Every 2 Rows Base on Filtered Results
    By allansy8 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-29-2014, 04:06 PM
  4. Replies: 3
    Last Post: 11-04-2013, 07:50 PM
  5. Pivot table not showing filtered results
    By Dan.Reynolds in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 05-28-2013, 02:09 PM
  6. Replies: 4
    Last Post: 08-16-2012, 06:20 PM
  7. Applying formulas to a table of filtered results
    By jovialtom in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-21-2007, 07:21 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1