0

I have an excel tower graph that is linked to a table that has a lot of categories. Most of these categories contain values that are 0 but may be changed to a value greater than 0 in the future. Since the chart is auto updating based on the values in the chart, is there a way to make the graph only show the values greater then 0.

Improve this question
3
  • Please clarify your specific problem or provide additional details to highlight exactly what you need. As it's currently written, it's hard to tell exactly what you're asking.
    – Community Bot
    Commented Nov 10, 2023 at 22:06
  • 2
    Depending on exactly what you want for results, you could either use a fliter to filter out the zero's, or you could replace the zeros with #NA
    – Ron Rosenfeld
    Commented Nov 12, 2023 at 13:27
  • The chart contains 2 rows, one with the names and one with the values. Is it possible to remove the names if ther value is = to 0, or n/a
    – edson
    Commented Nov 13, 2023 at 19:01

0

Reset to default

You must log in to answer this question.

Browse other questions tagged .