Create Graphs and Diagrams on Different Data with Excel

Create Graphs and Diagrams on Different Data with Excel. Hello fellow Arisha! Are you looking for a way to create graphs and diagrams on different data with Excel? Don’t worry, because this article will discuss it in full for you!

Data Preparation

Before creating a graph or diagram in Excel, make sure the data to be used is ready and well structured. If not, you can use the Sort and Filter feature in Excel to help sort and filter data. Apart from that, make sure the data used is clean and there are no empty or invalid values ​​that could affect the final results of the graph or diagram.

Creating Graphs on Different Data

If you have different data in one worksheet in Excel, you can create a graph in the following way:

1. Select all the data you want to display on the graph, including column and row labels or titles.
2. Click the “Insert” tab on the Excel ribbon, then select the type of graph you want to create.
3. Excel will automatically create a graph with the selected data. You can make additional settings such as changing the graph type or adding labels to the x and y axes.

Create Diagrams on Different Data

Apart from graphs, Excel also provides various types of diagrams that can help you visualize different data in one worksheet. How to make it is as follows:

1. Select all the data you want to display in the diagram.
2. Click the “Insert” tab on the Excel ribbon, then select the type of diagram you want to create.
3. Excel will automatically create a diagram with the selected data. You can make additional settings such as changing the diagram type or adding labels to each part of the diagram.

Save Graphs and Diagrams

Once you have finished creating a graph or diagram, make sure to save it properly so you can use it in a presentation or report later. The way to do this is to right click on the graph or diagram, then select “Save as Picture”. You can choose the desired file format such as JPEG or PNG, then save it in the desired folder.

Adding Graphs or Diagrams to PowerPoint

If you want to use a graph or diagram that has been created in PowerPoint, you can copy and paste it directly from Excel to PowerPoint. The way to do this is to select a graph or diagram in Excel, then press the “Ctrl + C” keys. Open PowerPoint, then press the “Ctrl + V” keys to place the graph or diagram on the PowerPoint slide.

Saving Graphs or Diagrams on Google Drive

If you want to save graphs or diagrams on Google Drive, you can do the following steps:

1. Right click on the graph or diagram, then select “Save as Picture”.
2. In the dialog box that appears, select the desired file format and click “Save”.
3. Open Google Drive and select the folder where you want to save the graph or diagram file.
4. Click the “New” button at the top left, then select “File upload”.
5. Select the saved graphic or diagram file, then click “Open”.
6. The graphic or diagram file will be uploaded to Google Drive and can be accessed from anywhere.

Displaying graphs or diagrams on blogs or websites

If you want to display graphs or diagrams on a blog or website, you can do the following steps:

1. Open the saved graphic or diagram file, then right click and select “Copy image address”.
2. Open the editor on the blog or website, then select the “Insert Image” or “Add Media” option.
3. Paste the copied image link in the URL or image address column.
4. Click “Insert” or “Add” to display the image in a blog post or website.

Changing the Display of a Graph or Diagram

If you want to change the appearance of a graph or diagram that has been created, Excel provides various setting options that can be adjusted to suit your needs. Some of them are:

1. Change the type of graph or diagram by selecting the “Change Chart Type” option on the “Design” tab.
2. Add or remove graph or diagram elements such as axis labels, lines, or areas by selecting the “Add Chart Element” option on the “Design” tab.
3. Change the appearance of the graph or diagram by selecting the “Chart Styles” option on the “Design” tab.
4. Modify data in a graph or diagram by changing values ​​or updating data in an Excel worksheet.

Conclusion

Creating graphs and diagrams on different data with Excel is quite easy and quick to do. Make sure the data used is well structured, then choose the type of graph or diagram that suits your needs. After you have finished creating a graph or diagram, don’t forget to save it and modify it according to your needs. Good luck! See you again in other interesting articles.