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

  • Thread starter Thread starter Zoe
  • Start date Start date
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
 
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
 
If I start x axis from -1 I dont want -1 to appear

Thank you
Zoe

Ο χÏήστης "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
 
Back
Top