Step 3: Click on Insert in the top menu bar while keeping the table selected. Step 2: Press Command+A (Mac) or Control + A (Windows) to select your table. Step 1: Open your spreadsheet in Microsoft Excel. It is a great option for filtering your data in small, digestible tables. You can avoid all the hassle by using the Slicer tool. There is a chance that you might get confused or lost while studying the numbers placed under various categories. Sometimes while analyzing the data in a table, the presentation of the metrics can get overwhelming. To change the icon type, theme and shape, simply click the Settings icon at the top-right corner of the People Graph. You will see a new People Graph in your sheet that represents the metrics of your table. Step 8: Select the data points from your table that you want to add to the People Graph. Step 6: Change the title of your People Graph to match it with your table.

Step 5: Select the People Graph image and click the Data icon at the top right. Step 4: Click and drag to move the People Graph away from the table. Step 3: Click the green icon next to ‘My Add-ins’ to add a People Graph.Ī default People Graph will appear in your sheet on the top of your table. Step 2: Click on Insert in the top menu bar. Step 1: Open Microsoft Excel and select your spreadsheet file. It will make your spreadsheet more lively and make the tracking metrics more related to humans. If you create reports with data points like app downloads, social media engagement, newsletter subscribers, and more, People Graph will a handy feature for you to represent your data in a visual manner. You can also change the Sparklines color by clicking the option in the top menu bar towards the right. You can repeat the steps and create Sparklines for every cell of your choice. Step 7: After selecting the cell, click the Ok button.Įxcel will create a mini graphy inside the selected cell. The Sparklines window will open up and ask you to select the cell for placing the sparklines. Step 6: Click the option and select your graph style. Step 5: Look for the Sparklines option towards the top right.

Step 4: Click on Insert at the top menu bar. Step 3: Select the fields whose data points you want to visualize. Step 2: Open a spreadsheet file you want to edit. Step 1: Open Microsoft Excel on your computer. This will help you to visualize the data in a better way. Sparklines is a feature of Microsoft Excel that allows you to create a mini graph inside a cell. Let’s say you are creating a table that includes data like monthly sales or daily weight loss progress.

We are using a Mac and the same steps apply to Windows users. This post will show you the best tips to format tables data in Microsoft Excel. The data tables full of numbers can be boring and you can give it an interesting spin using the built-in features of Excel.

How to add data analysis in excel mac