Hi All,

I have a macro creating a column chart. It takes category axis captions from
range("E1:AB1"), values from a selected row (row No is stored in a variable
"sourcerow"), so my VBA line is:

ActiveChart.SetSourceData Source:=Sheets(lapnev).Range( _
"E1:AB1,E" & sourcerow & ":AB" & sourcerow), PlotBy:=xlRows

It works well except that in some cases only every second caption is
displayed on the chart (E1 is displayed, F1 is left blank, G1 is displayed,
H1 is left blank, etc.). The value columns are correct above the blank
captions. I couldn't figure out any differences between correct and incorrect
cases.

How can I force to always display the whole caption range?

Thanks,
Stefi