Excel charts with dates on axis labels

Hi guys,

I have data like

Date C1 C2 C3 C4
4/20/2010 23 44 56 333
4/21/2010 23 45 57 334
4/22/2010 23 46 58 335
4/23/2010 23 47 59 336
4/26/2010 23 48 60 337
4/27/2010 23 49 61 338
4/28/2010 23 50 62 339
4/29/2010 23 51 63 340
4/30/2010 23 52 64 341


But the problem is when i make charts..Even when i select the x-axis labels as the "Date" field above,its showing Blanks on Dates 24,25 because as you can see from above data tat there is no data for 24,25 and only for 26 after 23..However,i want to show the above data as is without any blanks for 24,25 ...

Please help

Change the axis type to text instead of date. (Format Axis - Axis options - Axis Type: Text axis)

Hi huron,

thanks a lot for your help..