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.
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.
- How to unsubscribe from unwanted emails
- How to cross out or strikethrough text in Discord
- You can now buy an EVGA RTX 3090 Ti below MSRP
- Twitter accused of selling your phone number to advertisers
- Best Microsoft Office deals for May 2022