Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a table that with the following structure:
Year-Month
Items created
Items sold
Store
So, in some months we sold the stock and not as many as we created, for example:
Store Year-Month IC IS
1 2017-01 100 25
2 2017-01 20 7
3 2017-01 55 30
1 2017-02 50 30
2 2017-02 12 15
3 2017-02 40 16
1 2017-03 110 90
2 2017-03 28 7
3 2017-03 35 30
I have created a line chart to display the percentage of sales against creation. Like the following:
The information is displayed properly (the values are calculated IC/IS to get the percentage). The problem is with the log scale, it's not displaying correct or understandable values. If I removed the log scale I got the following:
The numbers cannot be read. Is there a way to manipulate the log scale to represent the data from 0 to 10% and then the rest. I will like to see the information as the first chart but with the scale similar to the second.
Is this possible?
Thanks,
Hi, also you can set the limits for the axis in the 'Scale' box. Set 0.1 in 'Static Max' to limit it to 10%
Hi,
Hi, also you can set the limits for the axis in the 'Scale' box. Set 0.1 in 'Static Max' to limit it to 10%
Will it be possible for you to provide sample data set?
This worked, however the numbers above 100% are not being displayed (as this one case and don't happened anymore I will leave it this way).
Thank you!
Hi Roberto, have you tried Fer answer to split the axis?
You can try splitting the axis and setting limits for each splitted axis, the bad thing about this is that usually the max limit label of the bottom chart overlaps with the min limit label of the upper chart.
Yes, I have tried that, but didn't work, that change didn't modify the chart.
Have you splitted the expressions between Top and bottom in the 'Position' box?
Once you have set the split axis you need to select wich expressions will go on the upper chart and wich go to the lower. If all expressions have 'Top' or all expressions have 'Bottom' it doesn't does anything
Don't know what you mean, if I clicked on Split Axis and select the Primary, but nothing happened. am I missing something?
Ok, it won't work with only one expression. I though you had more than one, sorry for confusing you.