Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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.

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
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.