Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 9
Default Charting - 2 questions simple scale and use of F11

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
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 5
Default Charting - 2 questions simple scale and use of F11

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" wrote in message
...
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



  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 427
Default Charting - 2 questions simple scale and use of F11

On Mon, 03 Jul 2006 14:07:25 +0100, Gilles Desjardins
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" wrote in message
...
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)
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 10:37 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"