I'm trying to create a pie chart in Excel that only shows data that has a value greater than one.

My data is not the result of a formula, and is just raw text. I still want the original data to be seen, I just don't want values of less than two to be shown in the pie chart.

Can anyone help?

  • Since pie charts are usually meant to show proportions of a whole (compare this part to the total amount), do you want the values less than two to be part of your total number that all the other values are compared to? – Rey Juna Jul 23 '18 at 20:58
  • Your requirements are a little ambiguous. Do you want to ignore all <2 values and look at the remaining values as basis for the 100%? Plot an "other" category to hold all of the <2 values? Add the <2 values to a specific other category (ex, the largest value)? – fixer1234 Jul 24 '18 at 2:05
  • Sorry if my question wasn't clear :). Ideally, I would like the values less than two to appear in the chart as an "other" category. - Thanks – The Tobemonster Aug 1 '18 at 10:09

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Browse other questions tagged or ask your own question.