•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
I'm stuck - how to create a pie chart (or any chart at this point) which shows top 10 values and sums all other values into "Others) BUT the source is a dynamic array (or Pivot Table).
I've been wracking my brain trying to come up with different solutions ranging from Pivot Chart to GROUPBY function from Excel but all come up short. Basically, my source data is going to be presented as a "per week" basis e.g.
Filter: Week 1
| Property | Hours |
|---|---|
| House A | 1 |
| House B | 2 |
| House C | 3 |
| House D | 1 |
| House E | 6 |
Different weeks might show different houses and different hours.
What I want the chart to show is just the top 10 houses with the most hours then all other houses would be lumped into "others" where all the hours are added up, that way I would minimize the amount of entries into the chart.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#Excel compatibility
#financial modeling with spreadsheets
#Excel alternatives
#data cleaning solutions
#rows.com
#big data management in spreadsheets
#generative AI for data analysis
#enterprise-level spreadsheet solutions
#conversational data analysis
#AI-driven spreadsheet solutions
#real-time data collaboration
#intelligent data visualization
#no-code spreadsheet solutions
#data visualization tools
#enterprise data management
#big data performance
#data analysis tools
#pie chart
#chart