Excel Tutorial - Excel Excel Settings To change your...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
Excel Excel Settings To change your general settings in Excel, you will invoke the Options Dialog Box with menu Tools, Options . The following dialog box will appear: It is here that you change your default settings for Excel. Creating Charts You can create charts (graphs) in Excel. Charts can be part of your worksheet or part of your workbook. To create a chart: select the data you want to chart (this can be done now or later) click on the ChartWizard button on the Standard toolbar, or you can use click on menu Insert, Chart . The following Chart Wizard dialog box appears: 1
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Excel Select the type of chart you want, click Next. Select the Data Range for your chart or click on the Series tab to manipulate your series, name, value, and axis labels. Click Next. Select the options you want to add or change in you chart. Decide whether you want the chart included in your worksheet as an object, or as a full page chart on separate sheet as part of your workbook. Click Finish. Editing Your Chart To edit your chart, first select it by clicking on either the chart object, or sheet tab. If your chart is an object, once selected you can move and resize the chart. Now that you've selected the chart to edit you can: 2
Background image of page 2
Excel Edit the Chart Setting created via the Chart Wizard. Click the Chart Wizard button to go through the Chart Wizard dialog boxes again, or right mouse click and the following will appear: The four selections circled in the menu are identical to the Chart Wizard steps 1 to 4. Editing a Specific Part of the Chart You can edit specific parts of the chart by placing the pointer over the desired area, and double-clicking on the area. Excel will display names for the areas you can edit. Areas differ depending on the type of chart, but common ones include: chart area legend category axis value axis plot area series Once you've double-clicked on the area, a respective dialog box will appear that will allow you to change various options for that particular area. Printing Your Chart
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 7

Excel Tutorial - Excel Excel Settings To change your...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online