http://chandoo.org/forums/topic/plot-highly-varying-data-in-excel-without-using-secondary-axes Ask Excel and Charting Questions, Muse about Visualizations, Learn and Share - Discussion Forums - Chandoo.org en-US Thu, 20 Jun 2013 02:15:01 +0000 http://bbpress.org/?v=1.0.1 q http://chandoo.org/forums/search.php http://chandoo.org/forums/topic/plot-highly-varying-data-in-excel-without-using-secondary-axes#post-19280 Thu, 23 Feb 2012 12:06:47 +0000 Faseeh 19280@http://chandoo.org/forums/ <p>@ Dawre, noted ur welcome. :D</p> <p>Faseeh </p> http://chandoo.org/forums/topic/plot-highly-varying-data-in-excel-without-using-secondary-axes#post-19277 Thu, 23 Feb 2012 11:37:29 +0000 dawre 19277@http://chandoo.org/forums/ <p>Thanks HUI :-)</p> <p>@Faseeh: Thanks 2 u 2! btw, u r spelling my name different every time!!! ;-)<br /> Its d..a..w..r..e</p> <p>Regards, </p> http://chandoo.org/forums/topic/plot-highly-varying-data-in-excel-without-using-secondary-axes#post-19274 Thu, 23 Feb 2012 09:54:03 +0000 Faseeh 19274@http://chandoo.org/forums/ <p>Thanks Hui, It is just wonderful!! @dewre you got it! </p> http://chandoo.org/forums/topic/plot-highly-varying-data-in-excel-without-using-secondary-axes#post-19272 Thu, 23 Feb 2012 09:51:59 +0000 Hui 19272@http://chandoo.org/forums/ <p>Have a look at: <a href="http://chandoo.org/wp/2010/08/20/charts-with-small-and-large-values/" rel="nofollow">http://chandoo.org/wp/2010/08/20/charts-with-small-and-large-values/</a> </p> http://chandoo.org/forums/topic/plot-highly-varying-data-in-excel-without-using-secondary-axes#post-19271 Thu, 23 Feb 2012 09:45:22 +0000 dawre 19271@http://chandoo.org/forums/ <p>Hi Faseeh,</p> <p>Thanks for the reply.<br /> 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!</p> <p>Regards, </p> http://chandoo.org/forums/topic/plot-highly-varying-data-in-excel-without-using-secondary-axes#post-19267 Thu, 23 Feb 2012 08:17:49 +0000 Faseeh 19267@http://chandoo.org/forums/ <p>Hi deware,</p> <p>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.</p> <p>Regards,<br /> Faseeh </p> http://chandoo.org/forums/topic/plot-highly-varying-data-in-excel-without-using-secondary-axes#post-19266 Thu, 23 Feb 2012 07:42:23 +0000 dawre 19266@http://chandoo.org/forums/ <p>Is there any way, on how to plot bar graph for highly varying data??</p> <p>for ex.</p> <p>col1 col2 col3<br /> 0001 0050 1000<br /> 0002 0010 2500<br /> 0003 0100 0999</p> <p>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 ) </p>