Nightlytic
Member
Can I please ask for a little help?
See attached,
I need the 'Bakery' to not show at all on the bar chart, if the corresponding total is 0 (this number is returned by a formula)
Essentially I have a challenge: can't use VBA, or pivot tables, allowed to create helper columns though.
I recon I either need to:
a. Automatically resize the chart selection area to exclude items that have a 0 (as result of formulae) and not therefore show them on the chart at all.
b. Get the charts to skip these gaps.
Maybe there's another solution. I researched this and can't see anything that gets rid of this empty space
See attached,
I need the 'Bakery' to not show at all on the bar chart, if the corresponding total is 0 (this number is returned by a formula)
Essentially I have a challenge: can't use VBA, or pivot tables, allowed to create helper columns though.
I recon I either need to:
a. Automatically resize the chart selection area to exclude items that have a 0 (as result of formulae) and not therefore show them on the chart at all.
b. Get the charts to skip these gaps.
Maybe there's another solution. I researched this and can't see anything that gets rid of this empty space