When you make a chart, Excel determines the scale of the Y-axis based on the numbers in your data set. If the range of your data (the difference between the highest and lowest numbers) is greater than 20% of the lowest number in your data set, then the Y-axis of your chart will go from [...]
Tag archives for charts
Change Excel’s Default Chart Type
If you make charts in Excel, you’ve probably noticed that Excel’s default is a column chart. That’s great if you make a lot of column charts, but what if you mostly make pie charts, or scatter charts, or those funny bubble charts? The good people at Tech Republic have written a great article that includes [...]
category: Excel


