Sign in to follow this  

How To Show Very Small And Big Values On The Same Line Graph?

Recommended Posts

Hi. We have an issue with line charts because some of the numbers we are plotting are for items with values in the tens of thousands but the majority are only within the hundreds. We need to display all of these on the same graph with timeline. When we do display all of these on the graph, the items with the lower numbers are all squashed together at the bottom (see the attached image) and you can’t see the Y-axis values for those. Is there a way we can divide the Y-Axis so that it could give more space for smaller values and less for the higher. For example, it could be 0-1000, 1000-5000, then 5000-10000 and increments of 5K from there? If there’s not, do you know of any best practices to handle a problem like this?


Share this post

Link to post
Share on other sites



Could you please try using the Logarithmic charts from the PowerCharts pack to solve your purpose?

Ref.- Sample Log Line chart


The logarithmic column and line charts are very similar to the normal charts, but for the fact that these charts use a logarithmic axis instead of a normal linear axis.



Hope this helps. :)

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this