toolbar. Figure: .35a Insert Chart . The Chart Wizard has three main parts: • List of steps involved in setting up the chart, • List of chart types, and • The options for each chart type. At any time you can go back to a previous step and change selections.
Figure: .35b Chart Type . Choose a Chart type and its option type. Then click Next button. Figure: .35c Data Range .
In Step , Data Range , helps to manually correct any mistakes made in selecting the data. Click one of the options for Data series in rows or in columns . Check whether the data range has labels in the first row or in the first column or both. Then click the Finish button, or click Next to change some more details of the chart.
Figure: .35d Data Series . The Data Series list box contains a list of all data series in the current chart. • To organize the data series, select an entry in the list. • Click Add to add another data series below the selected entry.
The new data series has the same type as the selected entry. • Click Remove to remove the selected entry from the Data Series list. • Use the Up and Down arrow buttons to move the selected entry in the list up or down. This does not change the order in the data source table, but changes only the arrangement in the chart.
• Then click Next button Figure: .35e Chart Elements . In the Chart Elements page, chart a title and, if desired, a subtitle. Give a suitable title that draws the viewers’ attention to the chart: For example: Figure .35f has the chart Title as Mark Statement. Then click Finish to create chart..
Figure: .35f Final Chart Case Study: Create a spreadsheet file to store sales data of a particular product and present it in the form of Chart.