I have data in a time series that starts from 0 but i dont want x.

[Zoe]

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

 

[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

 

[Zoe]

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

Thank you
Zoe

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

 

[Jon Peltier]

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