Hello,
Don’t often make graphs so not sure if this is possible or not.
I have a set of data in which the numbers change depending on the users choice of drop down menu. This then filters into a graph.
Currently there are a lot of items on the X axis, I wondered if there was a way of excel automatically removing the items with 0 value and then obviously bringing them back if the numbers change?
Many thanks
Marc
Don’t often make graphs so not sure if this is possible or not.
I have a set of data in which the numbers change depending on the users choice of drop down menu. This then filters into a graph.
Currently there are a lot of items on the X axis, I wondered if there was a way of excel automatically removing the items with 0 value and then obviously bringing them back if the numbers change?
Many thanks
Marc
