How to Draw a Chart in Excel 2016 TUTORIAL

Create a chart with recommended charts

Excel for Microsoft 365 Excel 2021 Excel 2019 Excel 2016 Excel 2013 More than...Less

If you're exploring charts in Excel and having a hard time figuring out which one is right for y'all, and then you can attempt the Recommended Charts control on the Insert tab. Excel volition analyze your data and make suggestions for you.

1. Select the data yous want to use for your nautical chart.

2. Click Insert > Recommended Charts.

   

3. On the Recommended Charts tab, scroll through the list of charts that Excel recommends for your information, and click any nautical chart to see how your data will look.

   

   Tip:If y'all don't see a chart you like, click All Charts to run into all available chart types.

4. When y'all find the chart you lot similar, click information technology > OK.

5. Utilize the Chart Elements, Nautical chart Styles, and Chart Filters buttons adjacent to the upper-right corner of the chart to add together chart elements like centrality titles or information labels, customize the expect of your nautical chart, or change the information that'southward shown in the chart.

   

6. To access additional blueprint and formatting features, click anywhere in the chart to add together the Chart Tools to the ribbon, and then click the options you want on the Design and Format tabs.

   

1. Select the data y'all want to use for your chart.

2. Click Insert > Recommended Charts.

   

3. On the Recommended Charts tab, scroll through the listing of charts that Excel recommends for your data, and click whatever chart to see how your data will await.

   

   Tip:If you don't see a nautical chart you lot similar, click All Charts to meet all bachelor chart types.

4. When you find the chart you lot like, click it > OK.

5. Use the Chart Elements, Chart Styles, and Nautical chart Filters buttons next to the upper-correct corner of the chart to add chart elements like axis titles or information labels, customize the look of your chart, or modify the data that's shown in the nautical chart.

   

6. To access additional blueprint and formatting features, click anywhere in the chart to add together the Nautical chart Tools to the ribbon, then click the options you want on the Design and Format tabs.

   

Recommended charts in Excel for the web creates interesting visuals about your data in a task pane.

Get started

1. Select the data y'all want to use for your chart.

2. Click Insert > Recommended Charts.

3. Cull a chart to insert from the Recommended Charts task pane, and select the + Insert Pivot Chart or + Insert Chart option.

4. If you choose the Pivot nautical chart selection, and then Excel volition insert a new worksheet for yous with a PivotTable that is the data source for the Pivot Nautical chart you selected. Each time you utilise the Insert Pivot Chart option, Excel volition insert a new worksheet. If you choose the Insert Nautical chart option, Excel will insert a chart directly on the worksheet with your source data.

   

Not sure how to get started?

If you lot're non sure how to get started, we'll give yous some sample data you can experiment with.

1. Add a new worksheet -- You can right-click on any sheet tab, and then select Insert.

2. Go to Insert > Recommended Charts, and Excel will load the Recommended Charts pane.

3. Select the Endeavor sample data push.

   

   Excel will add some sample data to your worksheet, analyze it, and so add together recommended charts to the pane.

4. Follow the steps in the Become Started section to insert any of the recommended Pin Charts or charts.

Need more aid?

You can ever ask an expert in the Excel Tech Customs or get back up in the Answers customs.

See Also

Available nautical chart types in Office

Become Microsoft chart templates

Need more help?

DOWNLOAD HERE

How to Draw a Chart in Excel 2016 TUTORIAL

Posted by: gladysthemot.blogspot.com