So what should you do? The answer is to strike a balance. Many people in your audience may not see that your values do not begin from zero, and some charts created this way may forego the values within the axis altogether.
But chart purists differ, and in many ways they are right because although your comparisons are pronounced, they are also not the truth-at least not the whole truth. This makes the difference between the various columns more pronounced. Yes, we did show you how you can change the Minimum and Maximum values on the Value Axis. If you compare the charts in Figure 7 with the charts in Figure 2, you will find that these changed charts provide a more pronounced contrast for the data.įigure 7: Charts with changed Maximum and Minimum values on Vertical axis Now you can see that the maximum and minimum values on the value axis have changed to the new values. Once you are done, click OK within the Format Axis dialog box to get back to your slide.For our sample chart, the Maximum value was changed to 370.įigure 6: Maximum Vertical axis value changed Similarly, deselect the Auto check-box in front of the Maximum option, and then type a new maximum value, as shown highlighted in red within Figure 6, below.For our sample chart, the Minimum value was changed to 250.įigure 5: Minimum Vertical axis value changed Deselect the Auto check-box in front of the Minimum option, and then type a new minimum value, as shown highlighted in red within Figure 5, below.As you can see, the Minimum and Maximum options are set to Auto by default, which is indicated by the Auto check-boxes selected in front of these options. Within the Format Axis dialog box, locate the Minimum and Maximum options, highlighted in red within Figure 4, above.
Now, select the value axis of the chart.Considering our sample chart data, we decided to set our minimum value to be 250 (less than 285) and the maximum value to be 370 (more than 365). Now decide the minimum and maximum values to be assigned for your value axis. Our chart data that you saw in Figure 1 earlier on this page has a minimum value of 285, and a maximum value of 365. First of all, take a look at your chart data and note what your minimum and maximum values.But, the same techniques will work for bar charts too.įollow these steps to learn more in PowerPoint 2011 for Mac: In the following steps, we are using our column chart as an example. Learn more about the various types of Chart Axes here.įortunately, you can easily choose your own maximum and minimum values. The value axis is the vertical axis on the left of a typical column chart, or the horizontal axis at the bottom for a bar chart (see Figure 2, above).
0 kommentar(er)
