View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
johannes johannes is offline
external usenet poster
 
Posts: 24
Default the date value of series is incorrectly displayed

I'm drawing a 3d graph with 2 series of data. The graph is displayed as 2
separate rows of bars behind each other. In Excel 2007 the type is Colum in
the first row to the far right.

1. series is a units of work. y -axis displayed in units of Thousands
2. series is a date when the units were done. x -axis.

If I hover over the the date bar in the 2nd bar row I can see all the right
values
including the right date.

the table is:

10000 1.11.2009
10000 3.11.2009
50000 10.11.2009 (in fact todate() function

All the dates are displayed as 9.02.1900 if I try to display them as Data
labels.

The dates are displayed correctly if displayed as x -axis labels.

Any ideas to correct this?