Hello,
I am trying to automatically remove, from a Bar Graph, text values from the X-axis, when the value is zero.
This is best illustrated via the example below:
Sample Data:
Product / Units Sold in NA / Units Sold in EU
Aces / 5 / 7
Goobers / 0 / 8
Wizbangs / 10 / 0
I have created two different bar graphs:
Graph 1 - Units sold in NA
Graph 2 - Units sold in EU
For Graph 1 the horizontal axis should display only only Aces and Wizbangs.
For Graph 2 the horizontal axis should display only Aces and Goobers.
The real data is substantially larger and the values/products are updated on a monthly basis, hence an automated approach is needed. I have tried using various macros, without success.
Thank you!
I am trying to automatically remove, from a Bar Graph, text values from the X-axis, when the value is zero.
This is best illustrated via the example below:
Sample Data:
Product / Units Sold in NA / Units Sold in EU
Aces / 5 / 7
Goobers / 0 / 8
Wizbangs / 10 / 0
I have created two different bar graphs:
Graph 1 - Units sold in NA
Graph 2 - Units sold in EU
For Graph 1 the horizontal axis should display only only Aces and Wizbangs.
For Graph 2 the horizontal axis should display only Aces and Goobers.
The real data is substantially larger and the values/products are updated on a monthly basis, hence an automated approach is needed. I have tried using various macros, without success.
Thank you!