View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ali
 
Posts: n/a
Default Category Labels(X) axis on a chart:

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?