In terms of reporting, it is important to present your data in a comprehensive manner. Learning how to create a chart in Excel will help you effectively share your data without hiding all the information in the word. Use this simple guide to Make A Graph in Excel.
Learn How to Make A Graph in Excel With These Steps
Step 1: Input Data into Excel
Before you can generate the required graphics, you must first determine which data to display. You can get your own research results or survey data from outsourced tools. You can also integrate one or two formulas to make it easier for you. Be sure to enter data for each topic in each column.
For example, for a chart that identifies the most popular pets in your neighborhood, you can enter the name of the street in the first column. The next column may include a variety of pets. Now fill in the remaining lines with the number of pets owned by the family on each street.
Step 2: Choose The Type of Graph to Use
Now that you have the information you need, you can now import it into your chart. Select the type of chart you want to use for your report – lines, bars, pies, and more.
To create a graphic, first highlight the data you want to use (that is, the information you entered earlier). Then go to the “Insert” tab and select the type of chart you want. After clicking on it, the graph will be displayed in Excel, showing the data you have previously entered.
Step 3: Change Graph Type
If you feel that the generated chart does not display the data correctly, you can easily change the chart. Go to the Design tab and click Change Chart Type.
Choose from a list of available charts. You can also make 3D or normal 2D. Check the results to make sure it is the type of graphics you want. If not, repeat this step. keep it as it is!
Step 4: Edit Data
You can also change the data that was originally placed. Simply go back to the column you want to update and edit the information. If you are from the bottom to the left of the diagram, it is also called the X and Y axes.
Go to the Data tab and click Switch Rows/Columns.ant to rearrange the data and return the column containing the information. Go to the Data tab and click Filter. Now highlight the columns you want to rearrange and choose From Min to Max or From Max to Min as needed.
You can move the da