• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Plot highly varying data in excel (without using Secondary Axes)

D

dawre

New Member
Is there any way, on how to plot bar graph for highly varying data??


for ex.


col1 col2 col3

0001 0050 1000

0002 0010 2500

0003 0100 0999


if we plot col1 on X axis with the two bars col2 and col3 values on Y axis... col1 is almost negligible size. NOTE ( i do not want to use SECONDARY AXIS )
 
Hi deware,


I donot think that it will be that small!! One way could be to use a multiplying factor but i think that is no appropriate bcz that will change the entire presentation of ur graph. My advice is that keep this graph as it is bcz graph is used for visual comparison, if u some how resize the col2 to appear large, u will compromise its ability to be compared visually.


Regards,

Faseeh
 
Hi Faseeh,


Thanks for the reply.

That set of data was just an example. In the actual set of data there are cases where the bar is just not visible!! so was just fancing my chances on you experts to get some solutions!


Regards,
 
Have a look at: http://chandoo.org/wp/2010/08/20/charts-with-small-and-large-values/
 
Thanks HUI :)


@Faseeh: Thanks 2 u 2! btw, u r spelling my name different every time!!! ;-)

Its d..a..w..r..e


Regards,
 
You must log in or register to reply here.
Back
Top