Exploring charts in Excel and finding that the one you pick isn’t working well for your data is a thing of the past! Try the Recommended Charts command on the Insert tab to quickly create a chart that’s just right for your data.
- Select the data you want to chart.
- Click the Insert tab, and then do one of the following:
- Click Recommended Charts and select the chart type you want.
OR - Click a specific chart type and select the style you want.
- Click Recommended Charts and select the chart type you want.
- With the chart selected, click the Chart Design tab to do any of the following:
- Click Add Chart Element to modify details like the title, labels, and the legend.
- Click Quick Layout to choose from predefined sets of chart elements.
- Click one of the previews in the style gallery to change the layout or style.
- Click Switch Row/Column or Select Data to change the data view.
-
Click Change Chart type to switch to a different kind of chart.
- Click Add Chart Element to modify details like the title, labels, and the legend.
Source: office.com
What's your reaction?
LOL
0%
Cheers
0%
What!?
0%
Meh...
0%
Sad
0%
RAGE!
0%
Create a chart from start to finish – mac 2016
Learn the elements of a chart Charts contain several elements, such as a title, axis labels, a legend, and gridlines. You can hide or display these elements, and you can also change their location and formatting. Chart title Plot area [...]
Create a chart from start to finish – mac 2011
Learn the elements of a chart Charts contain several elements, such as a title, axis labels, a legend, and gridlines. You can hide or display these elements, and you can also change their location and formatting. Chart title Plot area Legend Axis [...]
How to Make A Graph in Excel 2016 for Mac
This video will show you how to create a scatter plot on Excel 2016 for Mac. I provide examples for creating one line and two lines. Please let me know if you have any questions or want me to cover any other topics as I am open to suggestions! Make sure [...]
