Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Best way to visualize data with extreme value differences

I am working on some routines for a client application .The data is inconsistent  of smaller values and large values. For example:

456932

12

17

4569383

What will be the best way to visualize such data (Like in Bar chart it shows very uneven difference).Please suggest.

2 Replies
marcus_sommer

You could enable within the tab axis a logarithm scale or you tried to show your values with different units at the same chart like:

456932 = 456.9 K = 0.5 M

But in all of this is a big risk of misinterpreting the data through the user - therefore be very careful.

By a certain type of data like profit & loss categories could be a waterfall chart suitable: How to create Water Fall Charts.

- Marcus

swuehl
MVP
MVP