2

I have a graph with one negative value. I'd like to be able to

  1. Start the graph from the lowest value (in my example, -1) instead of 0
  2. I'd like the major axis to still show every 10 units from 0, so since I'm starting at -1, I'd like to show at 0, 10, 20 etc...

A screen shot of what want to AVOID

enter image description here

Greeny12m
  • 33

2 Answers2

2

Format the axis, and enter this as your custom number format:

[>=0]0;;;

The >= part can be zero or whatever other number you wish to set it at (in my case I wanted to exclude labels before a certain year, so my custom number format was [>=1972]0;;;.

rolve
  • 554
  • 5
  • 11
AJEagle
  • 21
2

You can't do that using the normal settings as they are designed. You would need a workaround. The least effort would probably be to specify a minimum Y axis value of -10 and a major division of 10. That would give you what you want except for a -10 axis label. Hide (cover) that so it isn't visible.

fixer1234
  • 28,064