View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.charting
Marko Pinteric
 
Posts: n/a
Default Category axis label problem at column chart



I was trying that already. More spaces, more of the digits of the time
are displayed. It takes around nine spaces to display the whole time.
The number of spaces depends on chart's properties.

Isn't there a more stable and elegant solution?

Marko.

Andy Pope wrote:
Hi,

Easiest thing is to include a space in the first cell.
(" "; "13:00"; ""; "14:00")

Cheers
Andy

Marko Pinteric wrote:


Dear experts!

I have a column chart. Category axis labels are either time ("hh:mm")
or empty ("") cells. If first value in the label range is time,
e.g. ("13:00"; ""; "14:00"; ""), everything is fine, in the opposite
case, e.g. (""; "13:00"; ""; "14:00"), labels are not displayed. It
seems that the chart calculate required space for labels according to
the first value in the label range.

Is there any way to solve this problem, so labels will be displayed
regardless of the fact if first value in label range is empty or not?

Thanks, Marko.