Excel 2010 - how to set format for horizontal axel in a diagram?

[senglory]

Please look at the attached XLSX file. Sheet1 contains a diagram with horizontal axel's format set to datatime. But it shows different values if to compare them with the original ones at EXCEL_DUMP worksheet. How I'm supposed to set the correct format on the diagram?

[Leith Ross]

Hello senglory,

As a courtesy, we ask that members please post the links to other groups where they have posted their question. This reduces duplication of answers and respects the time, effort, and knowledge of those helping you.

As a new member, please take some time to familiarize yourself with the rules.
Forum Rules


Cross posted at http://www.mrexcel.com/forum/showthread.php?t=516424

[Andy Pope]

Firstly none of the series in the chart are using the data in 'EXCEL DUMP_000021'!$A$2:$A$1303 as the x values. There for the chart defaults to using a simple numeric count. And because you have used a date format this displays dates from 01/Jan/1900.

Once you have corrected the data series to reference the data in column A you will need to change the chart to an xy-scatter rather than Line chart in order to see more than a single point, as your data has time as well as date value.

[senglory]

.

Thank you, it was exactly what I needed!