Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
nihhalmca
Specialist II
Specialist II

Custom Y-axis in bar chart

Hi All,

I want to custom y axis in bar chart, actually i have vales like 100 to 1000. If i take these values into bar chart as expression, Y axis is appears 0, 200, 400 ..... 1000 (vertically) by default however, i want to show y axis like 0, 50, 100, 150..............1000 (vertically).

How can i make it without increasing/expanding chart size.

Thanks,

Nihhal.

8 Replies
boorgura
Specialist
Specialist

In the chart properties, Axes tab -->use a static step of 50. That should help you.

nihhalmca
Specialist II
Specialist II
Author

Tried Rakesh, no use. You also try it if possible.

boorgura
Specialist
Specialist

can you please post a sample QVW?

nihhalmca
Specialist II
Specialist II
Author

LOAD * INLINE [

    Product, Price

    A, 100

    B, 200

    C, 500

    B, 800

    E, 300

    F, 1000

];

Anil_Babu_Samineni

The static step should be measure level? Can you show image at least.

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
qv_testing
Specialist II
Specialist II

Hi Nihhal,

Static Step Should work, but problem is it won't fit the values difference 50 gap..

Without expand chart, it won't fit, because we don't have enough space in Y-axis.

See here which i have marked, i given Static step 80, this is working.... if you give less than it won't appear.. because don't have enough space...

Capture.JPG

Suppose if you have less price... 50 difference difference should appear..  because values fit the scale..

Capture.JPG

Note: Without expand the chart, it won't work 50 difference.


Hope it helps....

qv_testing
Specialist II
Specialist II

I have an idea..

you can decrease font size in Y-Axis, that should appear 50 difference. But if you have more than this amount it won't work...

Capture.JPG

nihhalmca
Specialist II
Specialist II
Author

Yes Raju, I tried this and i mentioned in question as 'How can i make it without increasing/expanding chart size'.

Any ways thanks for your help.