I have 2 columns with values, say A and B which values I want to use as X and Y axes values correspondingly.

The values are the following:

A: 412 684 944 2009 9601

B: 7813,4 10377,6 11138,8 16216 606090

When I do it with help of wizard: Insert->2D chart->Right Mouse Click->Select Data after the data is selected it shows me the following chart that is not unfortunately scaled by X axis: enter image description here

Is there some way how I can automatically scale the X axis?

2 Answers 2


In order to do that, you must select the chart type as Scatter > Scatter with Straight Lines and Markers. Then your graph becomes this:

enter image description here

  • Ok, this is also fine :-)
    – Timofey
    Feb 28, 2011 at 13:56

The very first solution is to change the axis type: Double click on the axis->Axis options->Axis Type: Date Axis.

  • This won't help. Just try it. Feb 28, 2011 at 12:15
  • This helps, I have tried :-)
    – Timofey
    Feb 28, 2011 at 13:52
  • Well, how does Excel interpret these numbers when you format them as date?: 412, 684, 944, 2009, 9601. Feb 28, 2011 at 14:12
  • Nobody prohibits Excel to interpret the numbers as milliseconds
    – Timofey
    Feb 28, 2011 at 14:48

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.