The problem is caused by the first few cells of the category labels
range being empty.
Putting spaces in the first cell will cause the other text to be
displayed. The number of spaces required is dependent on the other text.

Cheers
Andy

Carlo wrote:
Hy Andy

thanks for your answer. unfortunately it didn't solve my problem.

If I resize the chart area to, let's say 130%, then everything is displayed
the correct way!
And that's the big problem, i can't change the format of the chart (i.e.
Size, Fontsize,
Colors...)

Would it help, if you would take a look at the File?

Thanks again

Carlo

"Andy Pope" wrote:


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

--

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