how to set a concrete value as the "zero" in a graphic axis

[sergiord2016]

hello ,

i want 100 to be the zero of my Y axis.



I want this grpahic to have he 100 value instead of the 0 and the id's with less than 100 measure to appear below the X axis.

could you help me please?

[hespora]

The most simple solution I can think of: Replace [cumpl] with [cumpl - 100]. Serves exactly that purpose.
/Edit: You could of course also just add a numeric baseline at 100.

Other than that, I'm looking through the properties of a Bubble Chart right now, and I do not see an option to move the axis intersection.

[sergiord2016]

Hi Hespora , thank you for the reply , but i am in the same case.

I did what you say and look:



I want -20 values ,-40 ,  -60 below the X Axis , becasue i want the 0 where -60 is now.

How can i put the zero where de .60 is? and make the negative values blow de X axis?

[hespora]

Hum... you're right. I'm not finding any option to move the x axis or to set the intersection at a specific value (i kinda assumed that it would default to zero, not to the minimum value, which is why i suggested the measure minus 100).

I guess you can always insert a baseline at your 100 value, and remove the x axis line. However, then you'll either omit the x axis major intervals, or have to also manually place those.

[sergiord2016]

Yes , numeric baseline would be the best option.

Thank you very much.