{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

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

Info icon This 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
Image of page 1

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

View Full Document Right 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
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.
Image of page 3

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

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

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern