Changing Axis Labels In Powerpoint 2011 For Mac

PowerPoint 2011 for Mac. On the slide below, for example, you'd like the label for the y-axis to rotate 90° CCW. You need to change a few things first though.

• How To Change Axis Labels In Powerpoint

Excel for Office 365 Word for Office 365 Outlook for Office 365 PowerPoint for Office 365 Excel 2019 Word 2019 Outlook 2019 PowerPoint 2019 Excel 2016 Word 2016 Outlook 2016 PowerPoint 2016 Excel 2013 Word 2013 Outlook 2013 PowerPoint 2013 In a, axis labels are shown below the horizontal (category) axis, next to the vertical (value) axis, and next to the depth axis (in a 3-D chart). Your chart uses text from its source data for these axis labels, but you can change that. Don't confuse the horizontal axis labels—Qtr 1, Qtr 2, Qtr 3, and Qtr 4, as shown below, with the legend labels below them—East Asia Sales 2009 and East Asia Sales 2010. To change the text of category labels in the source data on the worksheet:. Click each cell in the worksheet that contains the label text you want to change. Type the text you want in each cell, and press Enter.

As you change the text in the cells, the labels in the chart are updated. To keep the text in the source data on the worksheet the way it is, you can enter new label text that's independent of the worksheet data:. Right-click the category labels you want to change, and click Select Data. In the Horizontal (Category) Axis Labels box, click Edit. In the Axis label range box, enter the labels you want to use, separated by commas. For example, type Quarter 1,Quarter 2,Quarter 3,Quarter 4.

Change the format of text and numbers in labels To change the format of text in category axis labels:. Right-click the category axis labels you want to format, and click Font. On the Font tab, choose the formatting options you want.

On the Character Spacing tab, choose the spacing options you want. To change the format of numbers on the value axis:. Right-click the value axis labels you want to format.

Click Format Axis. In the Format Axis pane, click Number.

To change the stacking order for series in charts under Excel for Mac 2011:. select the chart,. select the series (easiest under RibbonChart LayoutCurrent Selection),. click Chart LayoutFormat Selection or MenuFormatData Series,. on popup menu Format Data Series click Order, then click individual series and click Move Up or Move Down buttons to adjust the stacking order on the Axis for the subject series. This changes the order for the plot and for the legend, but may not change the order number in the Series formula.

I had a three series plot on the secondary axis, and the series I wanted on top was stuck on the bottom in defiance of the Move Up and Move Down buttons. It happened to be formatted as markers only. I inserted a line, and presto(!), I could change its order in the plot. Later I could remove the line and sometimes it could still be ordered, but sometimes not. Excel 2010 - if you're looking to reorder the series on a pivot chart:. go to your underlying pivot table.

How To Change Axis Labels In Powerpoint

right-click on one of the Column Labels for the series you're looking to adjust (Note: you need to click on one of the series headings (i.e. 'Saturday' or 'Sunday' in the example shown below) not the 'Column Labels' text itself). in the pop-up menu, hover over 'Move' and then select an option from the resulting sub-menu to reposition the series variable. your pivot chart will update itself accordingly. This function gets the series names, puts them into an array, sorts the array and based on that defines the plotting order which will give the desired output. Function IncreasingLegendSort(mychart As Chart) Dim Arr ReDim Arr(1 To mychart.FullSeriesCollection.Count) 'Assigning Series names to an array For i = LBound(Arr) To UBound(Arr) Arr(i) = mychart.FullSeriesCollection(i).Name Next i 'Bubble-Sort (Sort the array in increasing order) For r1 = LBound(Arr) To UBound(Arr) rval = Arr(r1) For r2 = LBound(Arr) To UBound(Arr) If Arr(r2) rval Then 'Change ' to '.