how can you open chart wizard using menu . explain parts of wizard window ?
Answers
Answer:
Using the Chart Wizard
You can display the chart wizard by either selecting (Insert > Chart) or by pressing the chart wizard button on the standard toolbar.
Explanation:
There are four steps in the wizard which allow you to change the chart type, source data, chart options and location of your chart.
Step 1 - Chart Type - Lets you choose from the 14 different standard types of chart. Below the list of chart subtypes on the right hand side is a brief description to help you choose the right chart. There is also a "Press and Hold to View Sample" button that will display a preview of how the chart will look.
Step 2 - Source Data - Lets you select the cells and define the range to use for the chart. You can also choose whether you want to plot columns or rows as your data series. There are two tabs "Data Range" and "Series". The Series tab splits up the actual data range into individual series.
Step 3 - Options - Lets you define certain options for the chart (i.e. titles, axes, gridlines, legend, data labels and data table). This also displays a preview of how the chart will look.
Step 4 - Location - Lets you decide whether to display the chart on a separate chart sheet or as an embedded object on the active worksheet.
The advantage of using the Chart Wizard is that you can easily go back and change any of the options before you actually create the chart.
Answer:
Using the Chart Wizard. You can display the chart wizard by either selecting (Insert > Chart) or by pressing the chart wizard button on the standard toolbar