Horizontal axis with its real value

[Serkan]

Hello All,

I need to solve my problem that I am going to describe ASAP. Thanks in
advance for you help.

I want to draw very simple chart let say:

A B
1 11
2 12
3 13
20 14

I have the table above. I would like to draw B values by using A values in
horizontal axis. When the graph is drawn A values are their real values. So B
values on the graph is linear. So there is no difference in the graph if I
change the value of B from 20 to 4. What I want Excel to do is. I want it to
put value of the 20 not just next to 3 ( because its actual value is not 4).

How can I do it?

I know it is difficult to understand without showing the graph. I hope I am
able to explain my problem.

Thanks

 

[Del Cotter]

I want to draw very simple chart let say:

A B
1 11
2 12
3 13
20 14

I have the table above. I would like to draw B values by using A values in
horizontal axis. When the graph is drawn A values are their real values. So B
values on the graph is linear. So there is no difference in the graph if I
change the value of B from 20 to 4. What I want Excel to do is. I want it to
put value of the 20 not just next to 3 ( because its actual value is not 4).

Temporarily remove the letter "A" from the top of your first column
before running the Chart Wizard. It is not very bright, and needs the
gap to tell it what goes on the horizontal axis, even though no prompt
or documentation tells you this.

Alternatively, to repair a graph badly drawn by the Chart Wizard, simply
click on the A series and delete it, then right click on the B series
and modify it to give it the correct X values from the table.

 

[Mike Middleton]

Serkan -

Use an XY (Scatter) chart type.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel