Prev: Data labels along below x axis when y axis has negative values
Next: Dynamic Range
From: Serkan on 3 Jul 2008 23:06
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
From: Del Cotter on 4 Jul 2008 02:06
On Thu, 3 Jul 2008, in microsoft.public.excel.charting,
Serkan <Serkan(a)discussions.microsoft.com> 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(a)branta.demon.co.uk,
which goes to a spam folder-- please send your email to del3 instead.
From: Mike Middleton on 4 Jul 2008 02:47
Serkan -

Use an XY (Scatter) chart type.

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


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


 | 
Pages: 1
Prev: Data labels along below x axis when y axis has negative values
Next: Dynamic Range