Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Forced zero - How to suppress the zero lines in a chart?

Hi all, I was wondering if anyone could be of any help with this issue I have. I have a bubble chart with 4 dimensions and 3 expressions (which determine x and y axes and bubble size). Now I've enabled both axes but the zero lines are always there despite my attempts at suppressing them in the Axes tab and un-ticking Forced Zero. Can anyone tell me how to suppress those zero lines please?

9 Replies
aarkay29
Specialist
Specialist

Try changing the Static Min value

Properties>>Axes>Scale>>StaticMin

Not applicable
Author

Thanks Aar but I've tried that. I need to show the values under zero so I set the static min and max to values below zero but the zero lines are still showing. Any idea as to how I can suppress them at all?

aarkay29
Specialist
Specialist

Can you please share the sample file

Not applicable
Author

I'm afraid I can't do that Aar, sorry! I realise it could be much more helpful but there's confidential information in the package

aarkay29
Specialist
Specialist

Can you check if the axis width is set to '0'

Not applicable
Author

When the axis width is set to 0 the axis doesn't show at all and yes, the zero line disappears but I need to show the axes

aarkay29
Specialist
Specialist

Uncheck the Hide Axis and set the width to 0. This way you can see the data scale on axis but not the axis lines.

If you wish to see the lines too, then i am afraid that this is not possible since the zero axis line would show up.

Not applicable
Author

I agree i don't think it is possible either. Thank you very much for your help with this Aar!

EmmaC
Partner - Creator
Partner - Creator

Dear Ed, were you able to solve this?

regards, Emma