A chart is a graphical representation of worksheet data. It helps to analyze data and compare different worksheet values. A chart can be created in a separate chart sheet or embedded graphic object in a worksheet. Both embedded and chart sheets are linked to worksheet data. They are updated when the worksheet data changes. Before you can make a chart you must first enter data into a worksheet.
- Enter the data into the worksheet and highlight all the cells
- Go to Insert menu and click Chart, Or click ChartWizard button on Stander toolbar .
- Choose the the appropriate chart type Form chart type box
- Choose the the appropriate Sub chart- type Form sub chart- type box if necessary.
(To preview your information in any chart before you create it,click Press and Hold to View Sample)
- Click Next button
- Chart Source Data dialog box appears, Select the data range (if different from the area highlighted in step 1) and click Next.
- Chart Options dialog box appears, Enter the name of the chart and titles for the X- and Y-axes. Other options for the axes, grid lines, legend, data labels, and data table can be changed by clicking on the tabs.
- Click Next button
- Chart Location dialgo box appears, Click As new sheet if the chart should be placed on a new worksheet or select As object in if the chart should be embedded in an existing sheet and select the worksheet from the drop-down menu.
- At last Click Finished
Chart Formatting Toolbar
( Click the chart object, if the chart toolbar not show then Go to VIew Menu>>click toolbar>>Chart
Chart Objects List -
To select an object on the chart to format, click the object on the chart or select the object from the Chart Objects List and click the Format button. A window containing the properties of that object will then appear to make formatting changes.
Chart Type - Click the arrowhead on the chart type button to select a different type of chart.
Legend -
A box that identifies the patterns or colors that are assigned to the data series or categories in a chart.Show or hide the chart legend by clicking this Legend button
Data Table view -
Display the data table instead of the chart by clicking the Data Table button.
Display Data by Column or Row -
Charts the data by columns or rows according to the data sheet.
Angle Text -
Select the category or value axis and click the Angle Downward or Angle Upward button to angle the the selected by +/- 45 degrees.
|