How to Make a Chart and Graph

How to Make a Chart and Graph

Creating charts and graphs in Excel is a powerful way to visually represent and analyze data. Here is a step-by-step guide on how to make a chart and graph in Excel:

Prepare Your Data

Before creating a chart, ensure that your data is organized properly. Place the data you want to represent in a table format, with each column representing a different category or variable.

Select Your Data

Highlight the data you want to include in your chart. This should include the labels or headers for each column and the corresponding values.

Insert a Chart

Go to the “Insert” tab in the Excel ribbon at the top of the screen. Click on the “Chart” button to open the chart gallery. Choose the chart type that best suits your data, such as a column chart, bar chart, line chart, pie chart, or scatter plot.

Customize Your Chart

Once the chart is inserted, you can customize it to better visualize your data. Right-click on various elements of the chart, such as the axis labels, data points, or legend, to access formatting options. You can change colors, fonts, titles, and other visual aspects to make the chart more appealing and easier to understand.

Add Labels and Titles

Include descriptive labels and titles to make your chart more informative. Double-click on any element, such as the chart title or axis labels, to edit them. Clearly label the x-axis (horizontal) and y-axis (vertical) to provide context for your data.

Format Data Series

If your chart includes multiple data series, you can format them individually. Right-click on a data series, select “Format Data Series,” and adjust settings like color, style, or axis assignment.

Add Data Labels or Data Points

To make the data points more visible, you can add data labels or data points to your chart. Right-click on the data series or individual data points, select “Add Data Labels,” and choose the desired format (e.g., value, percentage, or category name).

What Are Graphs and Charts in Excel?

Graphs and charts in Excel are visual representations of data that allow you to convey information in a clear and concise manner. They help to present data in a more understandable and visually appealing format, making it easier to analyze and interpret the information. Here’s a breakdown of graphs and charts in Excel:


In Excel, graphs are graphical representations of data that display the relationship between variables. Graphs are commonly used to illustrate trends, comparisons, and patterns in data. Some common types of graphs in Excel include line graphs, scatter plots, area graphs, and radar charts. Graphs are particularly useful for showing how one variable changes in relation to another, such as plotting sales over time or displaying correlations between two sets of data.


Charts in Excel refer to specific types of graphical representations, each designed for a specific purpose. Excel offers various chart types, including column charts, bar charts, pie charts, doughnut charts, radar charts, and more. Charts in Excel are often used to represent data in a summarized or categorical format. They are effective for comparing different categories or displaying the composition of a whole. For example, a column chart can be used to compare sales figures for different products, while a pie chart can show the percentage distribution of expenses in a budget.

Key Functions and Benefits

Excel provides a range of features and functionalities for creating graphs and charts, including customization options for colors, labels, titles, and formatting. Key functions and benefits of using graphs and charts in Excel include:

Data Visualization

Graphs and charts help transform raw data into visual representations, making it easier to spot trends, patterns, and outliers.

Data Analysis

Visualizing data through graphs and charts allows for easier data analysis and identification of relationships between variables.


Graphs and charts present complex information in a concise and easily understandable manner, enabling effective communication of data insights to others.

If you required any then visit our website- Excel training in Chandigarh.

Read More Article-Sripx.

Leave a Reply

Your email address will not be published. Required fields are marked *