Log Scale is not displaying real values

[Anonymous]

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, 

[vvira1316]

You may want to check following discussion.

Logarithmic bar chart shows null dimensional value with larger count than other values is showing up...

If you are still having problem please include good size sample data

[vvira1316]

This one also

Data Point Value is not completely visible in a Bar Chart with a Log Scale