To select a chart element, you can either click the element or click the Current Selection pop-up menu found within the Chart Layout tab of the Ribbon. Selecting chart elements in Excel 2011 for Mac Here you find a selection indicator and chooser, selection formatting options, analysis options, label options, and 3-D rotation options.įormat: More fine-tuning using the selection indicator and chooser, chart element styles, text styles, arrangement, and size tools. This Ribbon tab has chart types, quick layouts, chart styles, sparklines, and data source controls.Ĭhart Layout: This Ribbon tab is where you fine-tune chart customization. When you save a Word document or PowerPoint presentation that contains a chart, the chart's underlying Excel data is automatically saved within the Word document or PowerPoint presentation.Ĭharts: This is where you start with your chart. If you insert a chart in Word or PowerPoint, a new sheet is opened in Excel.

However, the chart data is entered and saved in an Excel worksheet.I'll show you how to create standard and useful charts, and then how to fine tune those charts with a variety of techniques. In this course, we'll be looking at the concepts under line charts, and the tools to implement those concepts. Creating charts is one of Excel's most powerful yet easy to use features. Voiceover Hi I'm Dennis Taylor, and welcome to Excel for Mac 2016: Charts and Depth.For more information about the chart types that you can use, see Available chart types. The first box shows a list of chart type categories, and the second box shows the available chart types for each chart type category. In the Change Chart Type dialog box, click a chart type that you want to use.Practice while you learn with exercise files Download the files the instructor uses to teach the course. So, join me in Excel for the Mac 2011: Charts in Depth. When you click anywhere on a chart, the Office 2011 for Mac Ribbon displays three tabs from which to choose: One of the more subtle things to master with charts in Excel for Mac 2011 is training yourself to be aware of what is selected at any given moment.

Panel charts in excel for mac