how to plot a graph in excel 2016 from a table

Change the Chart Type in Excel: Instructions Then click the “OK” button at the bottom of this dialog box to change the selected chart type.Ĭhange the Chart Type in Excel – Instructions: A picture of a user changing the chart type of a selected chart in Excel. At that point, click the specific chart sub-type to apply. At that point, the different sub-types of the selected chart type appear in the list at the right side of the dialog box. The chart types appear in the pane at the left side of the dialog box. In the “Change Chart Type” dialog box that appears, click to select the type of chart to use. Then click the “Change Chart Type” button in the “Type” button group. Then click the “Design” tab of the “Chart Tools” contextual tab in the Ribbon. To change the chart type in Excel, select a chart or one of the chart’s elements. You may also need to reposition custom elements you have added to the chart area.

Either way, note that if you change the chart type, you may lose custom formatting you have applied to it. Alternatively, you can also choose a different sub-type of the same general chart type you first selected.

QuickBooks Desktop (PC/Windows) 2022-2015Īfter creating a chart, you can change the chart type in Excel.

Mac OS Ventura-Mojave Keyboard Shortcuts.

How to plot a graph in excel 2016 from a table