Menu
How to Move a Chart to Its Own Sheet in Excel. How-to Create a Dynamic Excel Pie Chart. Excel Dashboard Templates 142,385 views. How to Add Multiple Charts to an Excel Chart Sheet.
Released
7/25/2016 Charts allow you to communicate information visually, with greater impact than tables or raw data. They also happen to be one of the most powerful and easy-to-use features in Microsoft Excel for Mac. Let Dennis Taylor show you how to create different kinds of Excel charts, from column, bar, and line charts to doughnuts and scatter charts, and decide which type works best for your data. Learn how to fine-tune your chart's colors and style; add titles, labels, and legends; insert shapes and pictures; and pull data from multiple sources. Along the way, Dennis offers shortcuts and tips for being more productive and efficient. Topics include:- Selecting data for a chart
- Creating charts with keystrokes and ribbon icons
- Selecting the right chart type
- Adding titles, labels, and gridlines
- Choosing a chart layout
- Changing a chart's location
- Adding gridlines, data tables, and trendlines
- Formatting charts
- Creating column, bar, line, pie, and scatter charts
- Changing a chart's source data
- Creating Gantt and frequency charts
- Printing and sharing charts
- Converting a chart to a graphic
4h 22m
Duration
Show MoreShow Less
- [Voiceover] Hi I'm Dennis Taylor,and welcome to Excel for Mac 2016: Charts and Depth.Creating charts is one of Excel's most powerfulyet easy to use features.In this course, we'll be looking at the conceptsunder line charts,and the tools to implement those concepts.I'll show you how to create standardand useful charts,and then how to fine tune those chartswith a variety of techniques.You'll see how to add greater impact to your chartswith pictures and shapes,and then examine the most effective use of titles,labels, legends, axis, and grid lines.
We'll look at analytical tools that will help you makesense of chart data,and show you how to create dynamic chartsto reflect fast changing business environments,and we'll give you a ton of shortcuts and tipsthat will make your use of this popular toolmore efficient and productive.So join me in Excel for Mac 2016: Charts and Depth.
Related Articles
- 1 Automatically Text Wrap in PowerPoint 2007
- 2 Paste Excel Into PowerPoint & Change Format
- 3 Can You Take Pictures With the Kindle Fire HD?
- 4 Adjust Brightness on an iMac
Charts enable your company to display in compelling graphical format the contents of its Excel worksheets. Whether you've created a chart without a legend or deleted a legend from an existing chart, you can insert a new legend via the Legend button in the Charts group. After you've added your legend, Excel lets you customize a select set of legend properties, including placement and font styling.
1.Load the Excel worksheet containing the chart you want to edit.
2.Click the chart into which you want to insert a legend.
3.Click the 'Charts' tab on the ribbon to load the Charts group.
4.Click the 'Chart Layout' tab located immediately to the right of the Charts tab on the ribbon.
5.Click the 'Legend' button to display the Legend drop-down menu, and then click the button corresponding to where in your chart you want to insert the legend.
Tip
- Excel automatically inserts a legend with default formatting at your selected location in the chart. You can then format the legend's font and change its location via the Legend Options panel. To access the Legend Options panel, start by clicking your chart to select it. Click the 'Charts' tab on the ribbon, click 'Chart Layout,' click the 'Legend' button, and then click 'Legend Options' to load a list of customizable options for your legend. Click the 'Font' tab to customize the font. Click the 'Placement' tab to change where the legend appears on the chart.
Warning
- Information in this article applies to Excel 2011 for Mac. It may vary slightly or significantly with other versions or products.
References (3)
About the Author
Andrew Tennyson has been writing about culture, technology, health and a variety of other subjects since 2003. He has been published in The Gazette, DTR and ZCom. He holds a Bachelor of Arts in history and a Master of Fine Arts in writing.
Cite this Article Choose Citation Style
Tennyson, Andrew. 'How to Add a Legend on Excel for Mac.' Small Business - Chron.com, http://smallbusiness.chron.com/add-legend-excel-mac-75157.html. Accessed 13 October 2019.
Tennyson, Andrew. (n.d.). How to Add a Legend on Excel for Mac. Small Business - Chron.com. Retrieved from http://smallbusiness.chron.com/add-legend-excel-mac-75157.html
Tennyson, Andrew. 'How to Add a Legend on Excel for Mac' accessed October 13, 2019. http://smallbusiness.chron.com/add-legend-excel-mac-75157.html
Note: Depending on which text editor you're pasting into, you might have to add the italics to the site name.