Ms Excel -Chart In Excel Tips and tricks For Beginners

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.

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, let us choose 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 per-existing series can be deleted. And the data to be displayed on the X Axis. Let’s give her range and click on Next Button.

Step Third: -

This dialog box has six tabs. With which to set chart

This table is below.

•  Titles: - In this, the title of the chart gives the title of X and Y Axis.
•  Axes: From this table, determine whether to display labels on X and Y Axes in the chart.
•  Grid lines: - In this table Grid lines are determined in the chart.
•  Legend: - In this table, the position of the legend in the chart is determined that Legend has to show in the chart.
•  Data label: - What to display in the chart as a label. Let us choose it.
•  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.