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.
Enter the data in the excel sheet as shown in the figure.
Now select the data for which you want to show in graphical form. From the picture, select A1:D7.
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.
On the selected graph or chart, scroll down and enter the data for the axis.
After entering data, select the color scheme and data layout if you are comparing more than 2 values.
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.
Finally, add the title of the graph and click ok.
After the final graph is OK, you can add additional features by clicking anywhere on the graph.