Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
In the chart properties, Axes tab -->use a static step of 50. That should help you.
Tried Rakesh, no use. You also try it if possible.
can you please post a sample QVW?
LOAD * INLINE [
Product, Price
A, 100
B, 200
C, 500
B, 800
E, 300
F, 1000
];
The static step should be measure level? Can you show image at least.
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...
Suppose if you have less price... 50 difference difference should appear.. because values fit the scale..
Note: Without expand the chart, it won't work 50 difference.
Hope it helps....
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...
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.