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

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.


--

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