So this seems like it should be easy and maybe I'm stupid but I rarely use visuals of any kind in excel. I have 99 categories but need the pie to be 11 slices, top ten and the other 89 comprise "other". Is this possible? I'm looking to make the chart from the data on sheet sorted and specifically columns a-c. Please help.
A top 10 is fairly simple with a pivot chart or filter but the 'Other' part requires a little more work. I'd suggest a separate table driven by formulas for the chart. As an aside a pie chart is not a good choice in my opinion - they're generally not useful for displaying meaningful information.
Last edited by romperstomper; 02-14-2013 at 05:52 AM.
I believe I got everything I needed. Thank you for your help!
I have another question on the same workbook. On worksheet "chart", there is a small table directly below the chart. I'm really looking to have that information overlayed on the bottom right corner of the chart. I was hoping I could just send the chart to back, but that button is grayed out. Is this possible? I'll reattach since I've made some changes.
Edit: Nevermind, I know it's a different issue so it needs a separate thread.
Last edited by dropanddrive03; 02-14-2013 at 02:57 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks