LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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
 
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 07:41 AM.

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

About Us

"It's about Microsoft Excel"