How to Make Graphs in Excel? 8 Easy Steps

Published on Dec 17, 2023 by


Making graphs and charts is part of most of the people doing a job in sales and marketing departments. These people show the previous, present, and future forecasts in the form of graphs and charts. Many experts say that graphs and charts are the best way to visualize data clearly.

Moreover, finance and accounting department professionals need to learn how to forecast larger volumes of data in graphical form. In this article, you will learn how to make graphs or charts in excel.

Step 1: Create Chart/Enter Data:

Enter the data in the excel sheet as shown in the figure.

Step 2: Select the Data:

Now select the data for which you want to show in graphical form. From the picture, select A1:D7.

Step 3: Select Chart/graph Type:

Click the Insert Button/Tab, and select the chart or graph type. In the insert tab, you will find a lot of options like Pie charts, Bar graphs, Column graphs, and Dotted area graphs.

Step 4: Enter Data on Axis:

On the selected graph or chart, scroll down and enter the data for the axis.

Step 5: Color Adjustment:

After entering data, select the color scheme and data layout if you are comparing more than 2 values.

Step 6: Adding Elements:

With the help of chart elements, which is a chart filter in some versions, you can customize the look of the graph, add titles on the axis, and may change data.

Step 7: Tittle the Graph:

Finally, add the title of the graph and click ok.

Step 8: Adding Addition Features:

After the final graph is OK, you can add additional features by clicking anywhere on the graph.

About the Author: Andrew Webster

Andrew Webster is an esteemed writer and editor with a strong foothold in the realm of technology and gaming journalism. His career is marked by insightful and engaging articles that delve deep into the latest trends, game releases, and tech innovations. Known for his clear, concise writing style, Andrew adeptly navigates the ever-evolving digital landscape, providing his readers with timely and relevant content.

Leave a Reply

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

PHP Code Snippets Powered By :