How to break the data points

[prma7799]

Hi All,

How to break the values in X and Y axis like below

0.5

5

7.5

10

12.5

15

17.5 like this...........

Please see the attached

[sunny_talwar]

Not entirely sure I understand the requirement. What exactly are you trying to do?

[prma7799]

Hi Sunny,

I want to break the scale on both side like

0.5

5

7.5

10

12.5

15

17.5

as in the attachment have scale 0 5 10 15 20 and 0 -5 and right hand side 0 5 10 and -5 -10 -15....

(like seconds we have milliseconds )

[jagan · Accepted solution]

Hi,

In Axes tab set like this

Static Min : 0

Static Step : 2.5

for both the expresions.

Regards,

Jagan.

[prma7799]

Hi Jagan,

Your suggestion is right but i want to remove the zero in 5 10 15 20

PFA...

[HirisH_V7]

You can write in expression like ..if('Field'='0' or '7' ,Null())

Or

else Change number format settings.

Thanks.

[jagan]

Hi,

Then In Axes tab set like this

Static Min : 5

Static Step : 5

for both the expresions.

Regards,

Jagan.

[prma7799]

If i set like above then 2.5 7.5 12.5 will not visible.

[jagan]

Then set like below

Static Min : 2.5

Static Step : 2.5

Now you will get values like 2.5, 5, 7.5, 10, 12.5 etc.

Regards,

Jagan.