If you’re PivotTable aficionado, you will be in seventh heaven with the new PivotTable capabilities in Office 2011 for Mac. Adding Secondary Axis to Excel Charts Adding a secondary axis is very simple in all the versions of Excel (more so in the latest ones). In Excel 2011 for mac, a PivotTable is a special kind of table that summarizes data from a table, data range, or database external to the workbook. In the Format Chart Area pane, under Chart Options, click the Size and Properties tab. This combination chart now allows you to see the variation in both series of data Sales and profit margin values. You can freeze just the top row and first column or multiple rows and columns.
Tip: To maintain the proportions as you resize a chart, select the Lock Aspect Ratio check box between Shape Height and Shape Width.Ĭontrol how a chart moves and sizes with cells on the sheetĬONTROL+click or right-click, and then click Format Chart Area. Lock specific rows or columns in place by freezing panes, so you can scroll through an Excel spreadsheet and still see the top row or left column.
