Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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?

share|improve this question

2 Answers 2

up vote 2 down vote accepted

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

share|improve this answer
    
Ok, this is also fine :-) –  Tim Feb 28 '11 at 13:56

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

share|improve this answer
    
This won't help. Just try it. –  Mehper C. Palavuzlar Feb 28 '11 at 12:15
    
This helps, I have tried :-) –  Tim Feb 28 '11 at 13:52
    
Well, how does Excel interpret these numbers when you format them as date?: 412, 684, 944, 2009, 9601. –  Mehper C. Palavuzlar Feb 28 '11 at 14:12
    
Nobody prohibits Excel to interpret the numbers as milliseconds –  Tim Feb 28 '11 at 14:48

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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