I have data in a time series that starts from 0 but i dont want x axis to
start at zero I want it to start earlier but to not show on the graph

If it is an XY chart, or a line chart with a date scale, you can double
click on the X axis, and adjust the axis minimum scale.

What exactly don't you want to appear on the chart?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Zoe" wrote in message
...
I have data in a time series that starts from 0 but i dont want x axis to
start at zero I want it to start earlier but to not show on the graph

If I start x axis from -1 I dont want -1 to appear

Thank you
Zoe

Ο χÏ�ήστης "Jon Peltier" Î*γγÏ�αψε:

If it is an XY chart, or a line chart with a date scale, you can double
click on the X axis, and adjust the axis minimum scale.

What exactly don't you want to appear on the chart?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Zoe" wrote in message
...
I have data in a time series that starts from 0 but i dont want x axis to
start at zero I want it to start earlier but to not show on the graph

Ah. You can use a custom number format to suppress display of negative
numbers. A number format has four elements, for positives, negatives, zero,
and text. Suppose your format would be "0.0". To suppress negatives, leave
the negative slot blank in the custom number format:

0.0;;0.0;@

The @ just means treat text as it is entered. More on Excel's number
formats:

http://peltiertech.com/Excel/NumberFormats.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Zoe" wrote in message
...
If I start x axis from -1 I dont want -1 to appear

Thank you
Zoe

? ??????? "Jon Peltier" ???????:

If it is an XY chart, or a line chart with a date scale, you can double
click on the X axis, and adjust the axis minimum scale.

What exactly don't you want to appear on the chart?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Zoe" wrote in message
...
I have data in a time series that starts from 0 but i dont want x axis
to
start at zero I want it to start earlier but to not show on the graph