Forum Discussion

admin_xlsior's avatar
admin_xlsior
Post Prodigy
5 years ago
Solved

Trick for value too big

Hello guys,   Looking for idea or trick, let say in a column chart of months, when we have data value which is too big in particular month only, is there a way to make it more nice visibility, but ...
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi admin_xlsior ,

     

    Yes. You cannot use "log" option if there are some values that less than or equal to 0 in the field.

    Values are all positive.

    Changing the scale type from "linear" to "log" is a method to significantly reduce data fluctuations, you could have a try.

     

    Hope that's what you were looking for.

    Best Regards,

    Yuna

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

Jihwan_Kim's avatar
Jihwan_Kim
Super User
5 years ago

Hi, admin_xlsior 

Please try for the below.

 

 

 

Hi, My name is Jihwan Kim.

 

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

 

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

admin_xlsior's avatar
admin_xlsior
Post Prodigy
5 years ago

Hi Jihwan_Kim ,

 

I think I like that "Log" one, but I wonder why my selection is only Linear ->

 

Any thought why ?

 

Thanks,

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi admin_xlsior ,

     

    Yes. You cannot use "log" option if there are some values that less than or equal to 0 in the field.

    Values are all positive.

    Changing the scale type from "linear" to "log" is a method to significantly reduce data fluctuations, you could have a try.

     

    Hope that's what you were looking for.

    Best Regards,

    Yuna

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi admin_xlsior ,

       

      Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your problem.

       

      Best Regards,

      Yuna