bar chart? req

[#1]

pls find attached and i want  reduce bar size  based on req 

2000-   i want see upto  500    like wise all   but in  data base should  not change

[jagan]

Hi,

Try in Chart Properties-> Axes -> And give Static Min and Max values 0 and 500.

If this is not you are expecting explain in detail with some example.

Regards,

Jagan.

[MK_QSL · Accepted solution]

What is the logic you want ?

Here you are reducing 2000 by 500 and all other by 1000...

You can achieve the same by

Expression

Click on + Sign of SUM(SALES)

Bar Offset

Write below expression

IF(Year = 2000,-500,-1000)