I have a combo chart, bars and lines, with positive and negative values. I'd like to get a solid line across the chart at y=0. I don't really want the grid, with lines every 100 points or whatever. And I don't want to set the x axis at y=0 as my labels (dates) would just clutter up the chart.
Is this possible? Or is there a way to set the spacings on the grid so I get a line every 1000000000 points?
If you want to add a line in Y axis (primary or secondary). I suggest you to use the reference lines (Graph / properties / Presentation / Reference line. Click an Add then in Expression, put =0 (if you want a line at 0 value).
If you want to space the grid every 100 points : open the Graph properties / axes tab. Check the 'static Step' and write 100 in it.
The "more correct" way of doing it would be to go to the axis tab of chart properties and set the width of the expression axis to a value of 1 (it defaults to 0 for a cleaner look).
That's the one, thanks Johan. I had actually done this with the Dimension axis but thinking about it I guess it does make more sense for the zero line to be related to the Expression axis.
