Charting - 2 questions simple scale and use of F11

[SteveW]

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 ?

 

[Gilles Desjardins]

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]

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