If you use Excel regularly for work or studying that requires a spreadsheet to be filled with data-driven information, then you know it can be quite difficult and time-consuming to decipher, even more so for those who are not familiar with analytical-based data.
Whether a spreadsheet is complicated or not, the fact remains: Graphs help break down your data into an easily digestible format, enhancing the general readability of your Excel spreadsheet.
Here’s how to make a graph in Microsoft Excel.
Inserting a graph in Excel
Step 1: You’ll need to add your data into the Excel spreadsheet, with each column having its own dedicated title. In the first image below, we have entered a sample for demonstration purposes.
Step 2: Next, you’ll need to select the cells that contain all the data you wish to populate your graph with.
Step 3: Microsoft Excel provides a convenient feature that allows you to select from a number of templates for the graph. Click the Insert tab and then select Recommended charts.
Click a graph template of your choice and click OK.
Step 4: You can now customize the graph by changing its title (double-click Chart title), adjusting its size, etc.
Step 5: For a complete list of all the graph types you can apply, click the All charts tab. For example, you can select the Bar or Line charts, with each offering its own set of designs (3D, Clustered, Stacked, etc.).
Step 6: If you wish to change the graph type after choosing one, simply select the Change chart type button.
Step 7: You can also select a graph type from all the options within the section adjacent to Recommended charts. Clicking the drop-down arrow next to each icon and hovering over a thumbnail contained within that window will show you a preview of how it looks like with that specific design.
Editors' Recommendations
- Get this 22-inch monitor for $80 with this limited time deal
- How to build a PC from scratch: A beginner’s guide for building your own desktop computer
- ChatGPT: how to use the viral AI chatbot that everyone’s talking about
- Lenovo ThinkPad X1 Carbon just got a massive $1,800 price cut
- GPT-4: how to use, new features, availability, and more