Horizontal axis with its real value   

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

date: Thu, 3 Jul 2008 20:06:01 -0700   author:   Serkan

Re: Horizontal axis with its real value   

On Thu, 3 Jul 2008, in microsoft.public.excel.charting,
Serkan  said:
>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.

-- 
Del Cotter
NB Personal replies to this post will send email to del@branta.demon.co.uk,
    which goes to a spam folder-- please send your email to del3 instead.

date: Fri, 4 Jul 2008 07:06:02 +0100   author:   Del Cotter

Re: Horizontal axis with its real value   

Serkan  -

Use an XY (Scatter) chart type.

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


"Serkan"  wrote in message 
news:627CA3B4-3374-441D-8A54-CBDD835ED53E@microsoft.com...
> 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

date: Thu, 3 Jul 2008 23:47:46 -0700   author:   Mike Middleton