Welcome to MacForumz.com!
FAQFAQ   SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log in/Register/PasswordLog in/Register/Password

Help with Excel chart!

 
   Macintosh computer (Home) -> Excel RSS
Next:  Excel: Histogram?  
Author Message
buke120

External


Since: Feb 05, 2004
Posts: 1



(Msg. 1) Posted: Thu Feb 05, 2004 3:46 pm
Post subject: Help with Excel chart!
Archived from groups: microsoft>public>mac>office>excel (more info?)

I want to draw a chart where I need to have both X-axis and Y-axis as
value axes. Excel always makes X-axis as category axis. Is there a
way to change it to value axis? Thanks for your help.
Just as an example: if use the following data to draw a line graph, I
want to get a straight line, which is possible only when I have both
axes as value axes:


X axis values: 1, 2, 4, 5, 8, 9, 10.
Y axis values: 2, 4, 8, 10, 16, 18, 20.

 >> Stay informed about: Help with Excel chart! 
Back to top
Login to vote
Michael R Middleto

External


Since: Aug 29, 2003
Posts: 17



(Msg. 2) Posted: Thu Feb 05, 2004 5:09 pm
Post subject: Re: Help with Excel chart! [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

buke120 -

 > I want to draw a chart where I need to have both X-axis and Y-axis as
value axes. <

Use an XY (Scatter) chart type (not a Line chart type).

- Mike<!-- ~MESSAGE_AFTER~ -->

 >> Stay informed about: Help with Excel chart! 
Back to top
Login to vote
Display posts from previous:   
   Macintosh computer (Home) -> Excel All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]