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

Z

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
 
J

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
 
Z

Zoe

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

Thank you
Zoe

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top