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.
===========