how to make charts of numerical
Answers
Answer:
Step-by-step explanation:
Open your Excel worksheet and highlight the cells that contain your word and number variables. If your columns are not adjacent, copy and paste them into a new tab in your worksheet to simplify your sheet. Place your independent variable in the first column and dependent variable in the second column.
2
Select the "Insert" tab in the Ribbon at the top of the page. Click the drop-down box for the "Column," "Pie" or "Bar" chart type. These chart types allow number and word variables, where Line charts, Scatter charts, and Area charts require two numeric variables.
3
Customize the chart by clicking the "Design," "Layout" and "Format" tabs of the Ribbon. Change the color with the Chart Styles options of the Design tab, add data labels, titles and shapes from the Layout tab and modify the colors, fill and effects from the Format tab. Save your Excel spreadsheet when complete.