This seems like it should be really easy and maybe I am just missing something obvious.
I have a simple line chart with 2 lines, its databound.
Y axis is numbers
X axis are dates , last 12 months
It just shows numbers for each date, ie; 1 ,2 , 3 , 4 ..... 11, 12
I want the X axis label to show as dates but I can't figure out how to do it. Using the Chart wizard on the data tab if I set X-Axis to my date column the wizard just disappears before I even click OK. I have tried a few other ways and I get errors like: Unable to cast object of type 'System.DateTime' to type 'System.String'.
ideas?
thanks
I have a simple line chart with 2 lines, its databound.
Y axis is numbers
X axis are dates , last 12 months
It just shows numbers for each date, ie; 1 ,2 , 3 , 4 ..... 11, 12
I want the X axis label to show as dates but I can't figure out how to do it. Using the Chart wizard on the data tab if I set X-Axis to my date column the wizard just disappears before I even click OK. I have tried a few other ways and I get errors like: Unable to cast object of type 'System.DateTime' to type 'System.String'.
ideas?
thanks