View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default Display Issues with X-Axis

Hi,

Some checks,

that the category axis is linked to the correct cells.
Right click chart and pick Source Data. On the series tab is a box for
category labels range/text.

right click the chart and pick chart options. On the axis tab make sure
the X-axis is enabled.

double click the x axis and on the patterns tab see if TickMarkLabels is
set to None.

Cheers
Andy

Carlo wrote:
Hi All

i've some problems with a chart. To be precise, the chart works fine,
the only thing that doesn't work the way I want it to is the X-Axis, or
even more precisely the labels of the X-Axis.
I have a 2-Axis Chart, with a line-chart linked to the primary Y-Axis and
a bar-chart linked to the secondary Y-Axis.
Now I wanted the X-Axis to display the Label. Not really a miracle that
I'm expecting here, but Excel proves me wrong. Excel doesn't want to
show me the labels, so i started to change things, like chart-size, fontsize
and many other things, even Zoom. Well to be honest, if i would had to make
subtle changes I and my boss wouldn't have any problems changing them. But
the changes are all that big, that they are instantly recognizable if you look
at the chart!

Does anyone know of that problem?

I could even send you the .xls!?
Who knows, probably it works fine on your PC.

Thanks to all
Carlo



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info