Changing Axis Labels In Powerpoint 2011 For Mac
Here i have a column chart of binomial distribution, showing how many times you can expect to roll a six in 235 dice rolls: Note: You could also call it a binomial mass distribution for p=1/6, n=235 Now that graph is kinda squooshed. I'd like to change the Minimum and Maximum on the horizontal axis. Here is a totally different approach. The screenshot below shows the top of the worksheet with the data in columns A and B and a sequence of charts. The top left chart is simply an XY Scatter chart. The top right chart shows the distribution with the X axis scaled as desired. Texas tech microsoft office for mac.
Error bars have been added to the middle left chart. The middle right chart shows how to modify the vertical error bars. Select the vertical error bars and press Ctrl+1 (numeral one) to format them. Choose the Minus direction, no end caps, and percentage, entering 100% as the percentage to show. Select the horizontal error bars and press Delete (bottom left chart).
Format the XY series so it uses no markers, as well as no lines (bottom right chart). Finally, select the vertical error bars and format them to use a colored line, with a thicker width. These error bars use 4.5 points. You can run the following macros to set the limits on the x-axis. This kind of x-axis is based on a count, i.e.
Changing Axis Labels In Powerpoint 2011 For Mac Tutorials
Just because the first column is labeled some number, it is still 1 on the axis scale. If you want to plot columns 5 through 36, set 5 as the x-axis minimum, and 36 as the x-axis maximum.
(Do not enter a date for the kind of scaling you're trying to do here.) This is the only way I know of to rescale the 'unscalable' axis. Sub e1MinXAxis On Error GoTo ErrMsg MinXAxis = Application.InputBox(Prompt:='Enter Minimum Date (MM/DD/YYYY), Minimum Number, or Select Cell', Type:=1) If MinXAxis = 'False' Then Exit Sub Else ActiveChart.Axes(xlCategory).MinimumScale = MinXAxis End If Exit Sub ErrMsg: MsgBox ('You must be in a chart.' End Sub Sub e2MaxXAxis On Error GoTo ErrMsg MaxXAxis = Application.InputBox(Prompt:='Enter Maximum Date (MM/DD/YYYY), Number, or Select Cell', Type:=1) If MaxXAxis = 'False' Then Exit Sub Else ActiveChart.Axes(xlCategory).MaximumScale = MaxXAxis End If Exit Sub ErrMsg: MsgBox ('You must be in a chart.' Related to @dkusleika's but more dynamic. Here is the top part of a worksheet with the numbers 0 through 235 in column A and the probability of that many sixes being thrown in 235 tosses of a fair die in column B.
The Min and Max of the first column are given in E1 and E2, along with the initial chart of the data. We'll define a couple of dynamic range names (what Excel calls 'Names'). On the Formulas tab of the Ribbon, click Define Name, enter the name 'counts', give it a scope of the active worksheet (I kept the default name Sheet1), and enter this formula: =INDEX(Sheet1!$A$2:$A$237,MATCH(Sheet1!$E$1,Sheet1!$A$2:$A$237)): INDEX(Sheet1!$A$2:$A$237,MATCH(Sheet1!$E$2,Sheet1!$A$2:$A$237)) This basically says take the range that starts where column A contains the min value in cell E1 and that ends where column A contains the max value in cell E2. These will be our X values. Click on Formulas tab Name Manager, select 'counts' to populate the formula in Refers To at the bottom of the dialog, and make sure the range you want is highlighted in the sheet.
In the Name Manager dialog, click New, enter the name 'probs', and enter the much simpler formula =OFFSET(Sheet1!counts,0,1) which means take the range that is zero rows below and one row to the right of counts. These are our Y values. Now right click on the chart and choose Select Data from the pop-up menu. Under Horizontal (Category) Axis Labels, click Edit, and change =Sheet1!$A$2:$A$237 to =Sheet1!counts and click Enter. Now select the series listed in the left box and click Edit. Change Series Values from =Sheet1!$B$2:$B$237 to =Sheet1!probs If done properly, the chart now looks like this: Change the values in cells E1 or E2, and the chart will change to reflect the new min and max.
In your chart, Axis Labels are the labels for the Categories and Values on chart axes. Look at Figure 1 below that shows the default position of Axis Labels for a Column chart. Category names, which show as labels on the Horizontal (Category) axis have been highlighted in blue. Similarly Values show as labels on the Vertical (Values) axis - these are highlighted in red. Figure 1: Default Axis Labels in a Column chart So where do these labels come from?
Category Axis Labels reflect the Category names within your data (typically within the built-in Excel sheet). Values on the other hand are determined by PowerPoint based upon the maximum value in your data - the minimum value is always set to zero.
Of course you can if you want. Tip: If you don't know how to insert a chart, refer to our tutorial - you can also. Make sure your chart type supports axes.
Before you get started, you should have a chart inserted in your PowerPoint slide. We use a Column chart for this example. Follow these steps to learn how you can change your Axis Labels - let's start with changing Vertical (Value) Axis Labels:. Select the Value Axis of the chart on your slide and carefully right-click to access the contextual menu as shown in Figure 2.
From the contextual menu, chose Format Axis option (refer to Figure 2 again). If you do not get the Format Axis option in the contextual menu, you may have right-clicked on another chart element, make sure you then deselect anything in the chart, and then right-click on the Value Axis. Figure 2: Format Axis option selected for the Value Axis.
This opens the Format Axis dialog box, as shown in Figure 3. Figure 3: Format Axis dialog box In Figure 3 above, you can see all the Vertical axis' Minimum, Maximum, Major unit, and Minor unit options are set to default values - we know so because the Auto radio button is selected for all these options. If you, or, you will see the Vertical Axis Labels reflecting the changes you made.
To change any of these values, first you need to select the Fixed radio button associated with the option you want to change. Then, enter the required value within the box. Look at Figure 4 where we have set the Maximum value to 10 (highlighted in red) - you can see a of the Vertical Axis Label automatically reflecting this change, showing the Maximum value as 10 (highlighted in blue within Figure 4) - compare this to the original chart shown in Figure 1 earlier on this page. Figure 4:Value Axis Label reflecting the changed Maximum value Now, look at Figure 5 where we have changed the Display units to Hundreds (highlighted in red). Notice that the Vertical Axis Label now shows the changed display units (highlighted in blue within Figure 5). Figure 5: Value Axis Label reflecting the changed Display units You can also change the Value Axis Label to show as Currency. To do so, select the Number option in the sidebar (highlighted in green within Figure 6).
Thereafter select Currency within the Category list (highlighted in red within Figure 6) - you can choose the Currency symbol you need, and also set the required number of decimal spaces. You can see that the resultant Value Axis Label (highlighted in blue in Figure 6) is now set to Currency.
Figure 6: Value Axis Label changed to Currency You can similarly change the Value labels to show Percentages, Fractions, etc. Now, let us learn how to change the Category Axis Labels. First select your chart - then click the Edit Data button within the Charts Tools Design tab of the, as shown in Figure 7 (highlighted in red).
Figure 7: Edit Data button within Data group. This opens an instance of Excel with your chart data. Change the Category names within the Excel sheet - type new names for the Categories as required. Look at Figure 8 where we have changed our category names (highlighted in red). Figure 8: Category names changed within the Excel sheet. Exit Excel - the changes you make to the Category names in Excel will automatically be reflected in the Category Axis Labels on your chart within PowerPoint as shown in Figure 9 (highlighted in red) - compare this with the original chart shown in Figure 1, earlier on this page. Figure 9: Chart reflecting the changed category names.
Save your presentation.