Category Labels(X) axis on a chart:

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a Chart
Y-Axis shows percentages
X- Axis shows names of campanies
There are approximately 30 names in the Table.
On many months, the percentages are ZERO for most of the Companies, with
just a few companies having provided business. The chart is looking messy
with so many unnecessary names on the chart.
I would like to have a formula for the Category Label (X) Axis that names
will only appear on the charts X- Axis, IF the company percentage is greater
than 0%.
is this possible?
 
Hi Andy
Thanks, this makes sense. However, I would not know what formula to use if
I do not want any category label to show if the percentage is not greater
than zero?
Any ideas
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Remove the weekends from a pivot chart x axis 0
Using text as data? 0
How to put same scale on X and Y axis on graph 2
proper scaling in chart (with time-scale X-axis) 2
Value Axis Adjustment 2
Finding the weighted average of text that have been given values 1
Overlap graph multiple axis 1
Adding custom x axis labels to histogram generated from a pivot table 1

Back
Top