Excel charts and graphs tutorial pdf. Select microsoft office excel chart object. A chart is a visual representation of data in which the data is represented by symbols such as bars in a bar chart or lines in a line chart. Excel charts 1 in microsoft excel charts are used to make a graphical representation of any set of data. Drag it down and choose chart options.
On the design tab in the type group click change chart type. If you want to display the animals instead of the months on the horizontal axis execute the. To put the finish touches on the plot the graph and axes label click on the chart the graph itself and a menu item called chart should appear. Charts group you can find the charts group under the insert tab on the ribbon.
Excel is supported by both mac and pc platforms. To ensure that the entire chart is seen when pasted before you click the. Chart style gallery different chart styles that can be applied to your chart. Excel 2013 charts and graphs contents at a glance introduction.
Before she dives right in with creating her chart lucy should take some time to scroll through her data and fix any errors that she spotswhether its a digit that looks off a month spelled incorrectly or something else. Pick the right chart type for your data. 1 microsoft excel is one of the most popular spreadsheet applications that helps you manage data create visually persuasive charts and thought provoking graphs. Get your data ready.
Excel advanced charts fondren library short course monica rivero mpr1atriceedu methodology advance chart examples formatting tips methodology step 1. You can easily change to a different type of chart at any time. A step by step excel chart tutorial 1. Because excel automatically adjusts the ribbon to fit on your screen your copy of excel may show less options than the picture above.
Microsoft excel can also be used to balance a checkbook create an expense report build formulas and edit. Using excel 2013 to create charts 1 1 introducing charts in excel 2013 7 2 customizing charts 35 3 creating charts that show trends 77 4 creating charts that show differences. On the left side click column. You have an excel chart that looks like this.
The chart in the document or presentation will update as the chart is updated in excel.