A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

## Charts: (non-)fixed scale ##



 
 
Thread Tools Display Modes
  #1  
Old December 21st, 2003, 12:06 AM
Wai
external usenet poster
 
Posts: n/a
Default ## Charts: (non-)fixed scale ##

Product: MS Excel 2002 (English version)


Table: Weight of parcel and its price
Weight (kg) Price (=A3)
0 0
1 3.32
1.5 4.27
2 4.58
4 6.91
6 7.54
8 8.59
10 9.23
30 10.76

What I wish to do:
Create a line chart for the above.

However the chart I create is somewhat like below:
{X-axis} [fixed scale]
12
11
10
..
..
..
3
2
1
0
0 1 1.5 2... 10 30 {y-axis} [non-fixed scale]


i. I would like to create a chart which both X-, Y-axis=20
is at fixed scale.
The desired chart is somewhat like below:

{X-axis} [fixed scale]
12
11
10
..
..
..
3
2
1
0
0 1 2 3 4... 27 28 29 30 {y-axis} [fixed scale]


Other Q:
ii. How can I change X-axis or y-axis into fixed scale or=20
non-fixed scale?
iii. How can I omit some values in X-axis or y-axis?
Eg: I just wish to show values of "1-10", "25-30" in y-
axis, others (ie "11-24") should be hidden.


  #2  
Old December 21st, 2003, 02:13 PM
Bernard Liengme
external usenet poster
 
Posts: n/a
Default ## Charts: (non-)fixed scale ##

Hello,
A Line chart (in Excdel terminiology) is used when the x-values are
categoical (often text not numbers). What you need is an XY chart. This is
the type of thing you made in high-school mahs and called a graph.

Select the data, open the Chart Wizard, in Step 1 select an XY chart. Skip
the other steps and press Finish. Now you should have what you want but it
will need some tidying up. I suggest you get a simple book on Excel to learn
the basic of charting.

Season's Greetings
Bernard

"Wai" wrote in message
...
Product: MS Excel 2002 (English version)


Table: Weight of parcel and its price
Weight (kg) Price (£)
0 0
1 3.32
1.5 4.27
2 4.58
4 6.91
6 7.54
8 8.59
10 9.23
30 10.76

What I wish to do:
Create a line chart for the above.

However the chart I create is somewhat like below:
{X-axis} [fixed scale]
12
11
10
..
..
..
3
2
1
0
0 1 1.5 2... 10 30 {y-axis} [non-fixed scale]


i. I would like to create a chart which both X-, Y-axis
is at fixed scale.
The desired chart is somewhat like below:

{X-axis} [fixed scale]
12
11
10
..
..
..
3
2
1
0
0 1 2 3 4... 27 28 29 30 {y-axis} [fixed scale]


Other Q:
ii. How can I change X-axis or y-axis into fixed scale or
non-fixed scale?
iii. How can I omit some values in X-axis or y-axis?
Eg: I just wish to show values of "1-10", "25-30" in y-
axis, others (ie "11-24") should be hidden.



  #3  
Old December 23rd, 2003, 05:32 AM
Wai
external usenet poster
 
Posts: n/a
Default ## Charts: (non-)fixed scale ##

Thanks for your answer.
1. But is it possible for me to change its scaling style
(eg change X-axis or y-axis into fixed scale or
non-fixed scale?

2. Also is this previous question solvable:
===========
how can I omit some values in X-axis or y-axis?
Eg: I just wish to show values of "1-10", "25-30" in y-
axis, others (ie "11-24") should be hidden.
===========
  #4  
Old December 23rd, 2003, 01:42 PM
Jon Peltier
external usenet poster
 
Posts: n/a
Default ## Charts: (non-)fixed scale ##

1. Right click on the chart, select Chart Type from the pop up menu, and
choose either Line Chart or XY Scatter Chart, depending on whether you
want a categorical or numerical axis. For more info:

X Axis: Category or Value?
http://www.geocities.com/jonpeltier/...ValueAxis.html
Scatter Chart or Line Chart?
http://pubs.logicalexpressions.com/P...cle.asp?ID=190

2. To do this you need to massage your data, and to skip a range on your
axis, you need to construct a dummy axis:

Arbitrary Axis Scale
http://www.geocities.com/jonpeltier/...traryAxis.html
Chart Axes and Axis Tricks
http://www.geocities.com/jonpeltier/...arts/axes.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

Wai wrote:

Thanks for your answer.
1. But is it possible for me to change its scaling style
(eg change X-axis or y-axis into fixed scale or
non-fixed scale?

2. Also is this previous question solvable:
===========
how can I omit some values in X-axis or y-axis?
Eg: I just wish to show values of "1-10", "25-30" in y-
axis, others (ie "11-24") should be hidden.
===========


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:54 AM.


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