Set Minimum and Maximum Values on Value Axis in PowerPoint 2011 for Mac
Author: Geetesh Bajaj
Product/Version: PowerPoint 2011
OS: Mac OS X
Date Created: January 17th 2013
Last Updated: January 17th 2013
Excerpt/Capsule: Learn how to set the Minimum and Maximum values on Value Axis of Charts in PowerPoint 2011 for Mac.
Let's imagine that you need to create a chart from data where values are not too different. Our sample data, shown in Figure 1 below explores how people of different age brackets choose their favorite colors. If you look closely at the data, you will realize that all values span from between 285 and 365. So, does it makes sense to even discuss any value lower than 250 or above 370 for this data set. The answer to that question is not very easy to answer -- although we do show you how to show a more pronounced change in this tutorial, make sure you read The Ethics of Distortion box towards the end of this page.
Figure 1: What's your favorite color?
Yet when you create sample column and bar charts from this data using PowerPoint's defaults, you'll end up with charts akin to what you see in Figure 2, below. The chart on the top shows columns that are very similar in their heights -- there really is no contrast highlighting the findings of our data. It's the same story with the chart below where the bars look almost similar.
Figure 2: Value Axis in a Column chart and a Bar chart
The reason for lower contrast between values in these charts is that the Minimum and the Maximum values set for the Value Axis are calculated from a Minimum of zero -- this actually makes the differences in the column height or bar widths so much less pronounced -- and thus makes the chart much less effective as a visual medium.
Fortunately, you can easily choose your own Maximum and Minimum values. In the following steps, we are using our column chart as an example -- but the same techniques will work for bar charts too -- follow these steps to learn more:
- First of all, take a look at your chart data and note what your Minimum and Maximum values are -- 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. Now decide the Minimum and Maximum values to be assigned for your Vertical axis. 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, select the Value Axis of the chart -- right-click (or Ctrl+click) to access the context menu as shown
in Figure 3. From this context menu, chose the Format Axis option (refer to Figure 3 again).
Figure 3: Format Axis option selected for the Value Axis
- This opens the Format Axis dialog box, as shown in Figure 4.
Figure 4: Format Axis dialog box
Within the Format Axis dialog box, locate the Minimum and Maximum options (highlighted in red within Figure 4, above). 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.
- Deselect the Auto check-box in front of the Minimum option, and then type a new value within the box next to this option, as shown in Figure 5 (highlighted in red). For our chart example, the Minimum value was changed to 250.
Figure 5: Minimum Vertical axis value changed
- Similarly, deselect the Auto check-box in front of the Maximum option, and then type the Maximum value, as shown in Figure 6 (highlighted in red). For our chart example, the Maximum value was changed to 370.
Figure 6: Maximum Vertical axis value changed
- Once you are done, click OK within the Format Axis dialog box to get back to your slide. Now you can see that the Maximum and Minimum values on the Vertical axis changed to the new values. 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.
Figure 7: Charts with changed Maximum and Minimum values on Vertical axis
- Save your presentation often.
The Ethics of Distortion
Yes, we did show you how you can change the Minimum and Maximum values on the Value Axis -- this makes the difference between the various columns more pronounced. 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. 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. So what should you do? The answer is to strike a balance -- if you do alter the values to no longer start at zero, make that very apparent to your audience. Make sure you add a note to that effect on your slide, and even draw the attention of your audience to this fact.
If you liked this tutorial, do look at this book, authored by Geetesh Bajaj and James Gordon.
This book is the single most comprehensive content for Microsoft's latest Office suite offering for Mac users.
Check the book on Amazon.com...