X axis Dates not appearing correctly in combined chart

[ballstopicasso]

Hey all,

I got a problem with displaying my dates correctly on the X-axis of my combined column - line graph. For some reason X-axis labels appear as consecutive numbers with regards to number of data points. Please see attached. How can I work around this?

Also, why does the indent change as seen in this screenshot?

Last but not least, how can I prevent my secondary axis label from coinciding with the labels as seen here?

Thanks!

[Andy Pope]

Some of the dates appear as text.
Also you need to set the category range for both series.
Then you can set the axis to Date

Reduce the plotsize area to avoid labels clashing with title

[ballstopicasso]

Hi Andy,

Thanks for your input. It seems you've changed the type of the chart. Can you please review the file you've attached?

[ballstopicasso]

Andy,

I've also noticed that up to May 12th, the dates are written in DD/M/YYYY format. Beginning at the 13th, the format switches to M/DD/YYYY.

For some reason my indent difference also begins at this threshold. Isn't this weird?

[Andy Pope]

The chart type is unchanged. Column and Line combination.

Have your dates where text.