Chart in Excel
The chart option is used to display Excel data in a graph. The data is easy to understand from the chart. In Excel it is created by the wizard.
Chart Making in Excel: - In this, the chart is made in four steps. Which is as follows.
Chart Making in Excel: - In this, the chart is made in four steps. Which is as follows.
Step First
Insert menu → Chart
Or
Standard Tool Bar → Click on Chart Button
On clicking the chart button, a dialog box named chart wizard appears. In this, we select the type of chart and click on the Next button. There are fourteen types of charts in Excel.
Step Second
In the second step, we select the database for the chart. This dialog box consists of two tables. In the first table, give the data range and select it. Whether the data is in row or in the column belongs to the second tab series. In this, we give the name of the series and its range. A new series can be added to it. And pre-existing series can be deleted. And the data to be displayed on the X Axis. Let's give her a range and click on Next Button.
Step Third
This dialog box has six tabs. The table with which the chart settings are done
is the following.1. Titles: - In this, the title of the chart gives the title of X and Y Axis.2. Axes: From this table, determine whether to display labels on X and Y Axes in the chart.3. Grid lines: - In this table Grid lines are determined in the chart.4. Legend: - In this table, the position of the legend in the chart is determined that the legend has to show in the chart.5. Data label: - What to display in the chart as a label. Let us choose it.6. Data Table: - Whether or not to show the table of data of the chart, it is set.
Similarly, after making all the settings, click on the Next button.
is the following.1. Titles: - In this, the title of the chart gives the title of X and Y Axis.2. Axes: From this table, determine whether to display labels on X and Y Axes in the chart.3. Grid lines: - In this table Grid lines are determined in the chart.4. Legend: - In this table, the position of the legend in the chart is determined that the legend has to show in the chart.5. Data label: - What to display in the chart as a label. Let us choose it.6. Data Table: - Whether or not to show the table of data of the chart, it is set.
Similarly, after making all the settings, click on the Next button.
Step Fourth
In this step it is determined. Where to locate the chart on the current seat or the new seat. After this, the chart is created as soon as you click on Finish Button. After this, right-clicking on it can be done.
This is dummy text. It is not meant to be read. Accordingly, it is difficult to figure out when to end it. But then, this is dummy text. It is not meant to be read. Period.
ConversionConversion EmoticonEmoticon