A couple of easy - should be, but for the life of me I can't get it
figured.

Excell 2000
Simple list of 10 sequential numbers witha value for each

A B
101 5.5
102 6.9
103 3.5
etc etc

I want a graph with 101, 102 103 etc for the X-axis and a simple
connected line graph of the various points

In my case the actual data in column B are calculated and will be
between 0 and 10
If I just select column B and select a line graph, it uses X value of
1,2,3 - and for some reason I can't get it to use the A values as
labels

I can select A:B with a Line graph, I get 2 series 101,102,103.. and
column B values as 2 lines. With 1,2,3 on the x-axis.

A X-Y Scatter - works, but surely isn't the simplest way.


2nd question, when test this in a small chart, I usually use F11 to
convert this to a chart in-a-tab - but it does this a default chart
type not using the one I've already constructed
Is this right ?
--

Steve

Hi Steve,
Q1: Transform your 101,102 in column A to text, highlight both A & B press
F11

Q2: by pressing F11 a new chart is created on a seperate sheet as you have
discovered. There will be a default type used which you must change
manually.

HTh

Gilles
"SteveW" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>A couple of easy - should be, but for the life of me I can't get it
> figured.
>
> Excell 2000
> Simple list of 10 sequential numbers witha value for each
>
> A B
> 101 5.5
> 102 6.9
> 103 3.5
> etc etc
>
> I want a graph with 101, 102 103 etc for the X-axis and a simple
> connected line graph of the various points
>
> In my case the actual data in column B are calculated and will be
> between 0 and 10
> If I just select column B and select a line graph, it uses X value of
> 1,2,3 - and for some reason I can't get it to use the A values as
> labels
>
> I can select A:B with a Line graph, I get 2 series 101,102,103.. and
> column B values as 2 lines. With 1,2,3 on the x-axis.
>
> A X-Y Scatter - works, but surely isn't the simplest way.
>
>
> 2nd question, when test this in a small chart, I usually use F11 to
> convert this to a chart in-a-tab - but it does this a default chart
> type not using the one I've already constructed
> Is this right ?
> --
>
> Steve

On Mon, 03 Jul 2006 14:07:25 +0100, Gilles Desjardins
<(E-Mail Removed)> wrote:

> Hi Steve,
> Q1: Transform your 101,102 in column A to text, highlight both A & B
> press
> F11

That worked, but only when I retyped then as '101, '102 etc.
I couldn't convert the cells to text and get the right chart.

That at least proves it works, I'll set up some macro if required to
ensure the values 101,102 are in text form.
(The actual data could be 0 to 300, and the idea is to be able to chose a
block of data and plot that with the correct values on the x-axis)
>
> Q2: by pressing F11 a new chart is created on a seperate sheet as you
> have
> discovered. There will be a default type used which you must change
> manually.
>
Yes, maybe I had changed the default before - just shame when all you
really want if you click on a graph window - F11 should start off with the
same chart type etc etc, agreed default is what you'd want from data block
F11..

> HTh
>
> Gilles
> "SteveW" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> A couple of easy - should be, but for the life of me I can't get it
>> figured.
>>
>> Excell 2000
>> Simple list of 10 sequential numbers witha value for each
>>
>> A B
>> 101 5.5
>> 102 6.9
>> 103 3.5
>> etc etc
>>
>> I want a graph with 101, 102 103 etc for the X-axis and a simple
>> connected line graph of the various points
>>
>> In my case the actual data in column B are calculated and will be
>> between 0 and 10
>> If I just select column B and select a line graph, it uses X value of
>> 1,2,3 - and for some reason I can't get it to use the A values as
>> labels
>>
>> I can select A:B with a Line graph, I get 2 series 101,102,103.. and
>> column B values as 2 lines. With 1,2,3 on the x-axis.
>>
>> A X-Y Scatter - works, but surely isn't the simplest way.
>>
>>
>> 2nd question, when test this in a small chart, I usually use F11 to
>> convert this to a chart in-a-tab - but it does this a default chart
>> type not using the one I've already constructed
>> Is this right ?
>> --
>>
>> Steve
>
>



--
Steve (3)