Microsoft Excel Training Improve your Microsoft® Excel® skills and learn how to produce insightful business reports. • Discovering Excel: If you have basic Excel knowledge you would benefit from attending this intermediate Excel course. Word for mac free download.

Microsoft Excel charts give you a large number of options for displaying the data in your spreadsheet. Sometimes, it is useful and informative to plot two different. In Excel 2013 and Excel 2016 the steps are different: Right-click on the axis whose scale you want to change. Excel displays a Context menu for the axis. Instructions with a right click are not applicable to us iMac users. Can you include the instructions for Mac users?

• Excel on Steroids: If you use Excel extensively for business reporting, then this course is for you. The course is divided into three workshops covering specific topics in Excel. • Excel on Steroids Plus: Data analysis, visualisation and dashboards will teach you how to model your data, create interactive dashboard reports, and make analysing your data much easier, giving you clearer insights into your company. Microsoft Excel Training Improve your Microsoft® Excel® skills and learn how to produce insightful business reports. • Discovering Excel: If you have basic Excel knowledge you would benefit from attending this intermediate Excel course. • Excel on Steroids: If you use Excel extensively for business reporting, then this course is for you. The course is divided into three workshops covering specific topics in Excel.

• Excel on Steroids Plus: Data analysis, visualisation and dashboards will teach you how to model your data, create interactive dashboard reports, and make analysing your data much easier, giving you clearer insights into your company. Charts by default display a primary vertical axis when created. This works if there is only one unit of measure in the data. However, should there be different units of measure in your data, a secondary axis will be required, thus allowing you to create a dual chart in your Microsoft ® Excel ® workbook. In our practice exercise we are going to display the sales target and actual data on the primary axis as values, and the variance as a percentage on the secondary axis.

Note: You are welcome to to practice. Applies To: Microsoft ® Excel ® 2007, 2010 and 2013. Select the entire data range ( A2:D14) then press F11 to create a quick chart.

Right click on one of the series on the chart, and select format data series. Then under series options, select series variance. Right click on one of the variance series on the chart.

Select Format Data Series, then select Secondary Axis. Right click on one of the variance series and select Change Series Chart Type. Select line with markers under chart type for variance. Select OK, now right click on the Primary axis and select Format Axis. Enter 2500 under major units and select thousands next to Display units. Add a suitable chart title. Right click one of the horizontal grid lines and select delete.

The primary axis displays the target and actual data. As you can see, a secondary axis that displays the variance in percentages has been added, thus showing you a trend.

After you have created a chart in Excel, what's the first thing you usually want to do with it? Make the graph look exactly the way you've pictured it in your mind! In modern versions of Excel 2013 and Excel 2016, customizing charts is easy and fun.

• Premium versions of Word, Excel, PowerPoint, Outlook, Publisher, and Access* • OneNote: Access to additional OneNote features () • For use on multiple PCs/Macs, tablets, and phones (including Windows, iOS, and Android). • 1TB OneDrive cloud storage each for each person • Ransomware detection and file recovery.

Microsoft has really made a big effort to simplify the process and place the customization options within easy reach. And further on in this tutorial, you will learn some quick ways to add and modify all essential elements of Excel charts. • • • • • • • • • • 3 ways to customize charts in Excel If you've had a chance to read our previous tutorial on, you already know that you can access the main chart features in three ways: • Select the chart and go to the Chart Tools tabs ( Design and Format) on the Excel ribbon.

• Right-click the chart element you would like to customize, and choose the corresponding item from the context menu. • Use the chart customization buttons that appear in the top right corner of your Excel graph when you click on it. Even more customization options can be found on the Format Chart pane that appears on the right of your worksheet as soon as you click More options in the chart's context menu or on the Chart Tools tabs on the ribbon. For immediate access to the relevant Format Chart pane options, double click the corresponding element in the chart. Armed with this basic knowledge, let's see how you can modify different chart elements to make your Excel graph look exactly the way you'd like it to look. How to add title to Excel chart This section demonstrates how to insert the chart title in different Excel versions so that you know where the main chart features reside.