All articles with 'axis scaling' Tag

How do you make charts when you have lots of small values but few extremely large values? [Debate]

Published on Aug 20, 2010 in Charts and Graphs, Featured, Learn Excel
How do you make charts when you have lots of small values but few extremely large values? [Debate]

Here is an interesting charting problem we come across once in a while. We have a lot of small numbers and a few very large numbers. How do we effectively plot all of them in a chart?

Now, how do you go about making a chart?

Continue »

Sports Statistics Dashboard in Excel – Few More Alternatives

Published on Oct 24, 2008 in Charts and Graphs, Learn Excel
Sports Statistics Dashboard in Excel – Few More Alternatives

First of all, thanks everyone for making the should you always start barcharts at zero? discussion lively. Almost everyone felt that we should start bar charts at zero. After spending sometime with my initial test cricket statistics dashboard, I have created few alternatives. You can see them below. But somehow I feel that I haven’t […]

Continue »

Reader Poll: Should the axis for bar charts always start at zero?

Published on Oct 21, 2008 in Charts and Graphs, Featured, Learn Excel
Reader Poll: Should the axis for bar charts always start at zero?

It all began with my Excel Dashboard Tutorial – Making a dashboard with player statistics. I have used bar charts with axis whose minimum is not zero, to create a dramatic effect in the charts. See below: Jon Peltier commented saying that, Rule #1: Bar and column chart value axes should start at zero. Since […]

Continue »