1 / 16

LESSON-3

LESSON-3. Excel Charts. A chart is a graphic which provides visual representations of the workbook data, and is not located in a specific cell or range. Data Series – is a set of values that you want to chart. 255 data series can be plotted in a single chart.

liana
Télécharger la présentation

LESSON-3

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. LESSON-3

  2. Excel Charts A chart is a graphic which provides visual representations of the workbook data, and is not located in a specific cell or range • Data Series– is a set of values that you want to chart. • 255 data series can be plotted in a single chart. • Data point– Each value in a data series is called a data point i.e. the value in a cell. • A data series can contain upto 32,000 data points/values for 2 dimensional chart and 4,000 for three dimensional chart. • Category– is the label or heading under which the values are stored.

  3. Data Series & Categories Category Data Series Data point

  4. Chart Elements Chart Title Plot Area Chart Area Tick mark Data marker Y axis Title Legend Y axis Tick Mark X- axis X axis Title X axis Labels

  5. Chart Elements • Chart Area –the area where all the chart elements reside. • Plot Area – within the chart area where the chart is plotted i.e. the rectangular area bounded by the X and Y-axis. • Data Marker – is a graphic representation of value of data point in a chart. • Axis – is the line that contains a measurement by which you compare plotted value. • X-axis – contains data markers denoting category values. • Y-axis – contains the value of data being plotted.

  6. Chart Elements • X-axis Title –which briefly describe the X-axis categories. • Y-axis Title –identifies the values being plotted on the Y-axis. • Chart Title – which labels or describe the entire chart. • Tick Marks – are small lines similar to marks on a ruler, that are uniformly spaced along each axis and identify the position of category names or values. • Grid Lines – are the extensions of tick marks that helps identify the value of the data markers. • Legend – A chart legend indicates which data marker represents each series when you chart multiple series.

  7. Types of Excel Charts

  8. Chart Placement, Planning Chart can be placed in two ways • Embedded chart – Placing a chart near data in same worksheet. • Adv: Can see and print data and chart on the same page. • Chart sheet – Placing a chart on a separate sheet. • Adv:Much larger and No data on chart page. • Chart planning guidelines • What is the purpose of the chart i.e. comparison trend and etc? • What data to be represented by the chart? • Which chart type is the best to represent the data? • Where should the chart be placed - along with the data or on a separate sheet ? • What feature should the selected chart type contain - i.e. markers, legends etc? • Sketch the chart and decide finally.

  9. Creating a chart • A chart can be created using Chart Wizard (from Insert menu). • The Chart Wizard is a four-step, on-screen guide that helps you prepare a chart from an Excel worksheet. • Choose the chart type • Choose the data to chart and how it appears • Add chart options • Determine chart placement

  10. Moving and Resizing a Chart Selection handle Common mouse pointers

  11. Editing a Chart Changing data values in the worksheet automatically updates the chart Change value here… …see data marker change here

  12. Formatting a Chart Formatting Option • Formatting a Chart’s • Plot Area • Data Series • Chart Area

  13. Annotating a chart Annotation text Arrow • A text annotation is a label that you add to a chart to further describe data Improving a chart • You can improve a chart by including / deleting or updating a data series . • Insert or delete a column or row and update with data. • Drag the data range and include or remove in the chart.

  14. Working with 3-D Pie Charts

  15. Working with 3-D Pie Charts Working with 3-D Pie Charts -Select Chart from “Menu Bar” – chart option - then chose “3D view” • Click the Chart Wizard button • In the first step of the chart wizard, select the pie chart type and sub-type 3D with visual effect. • In the second step select chart's data range and series in ( row / column) • In the third step, make any modifications to the chart's appearance • In the fourth and final step, specify the location for the chart, then click the OK button

  16. Working with 3-D Pie Charts Exploded pie slice • Exploding a pie slice • Emphasize a pie slice in a pie chart • Click and drag the desired pie slice

More Related