How to create a people graph in Excel? - Excel Tips and Tricks - video Dailymotion

ExcelTips247

Learn how to create a people graph in Excel.   To create a People Graph in Excel, first, open your Excel workbook and enter your data in a table format. Then, select the data you want to visualize. Go to the "Insert" tab on the ribbon and click on "People Graph" under the "Add-ins" section. A new People Graph will appear, and you can customize it by clicking on the graph to open the settings pane where you can change the title, data labels, and style. Using People Graph in Microsoft Excel is a simple and effective way to visually represent data about people, such as survey results or demographic information, making it easy to understand at a glance.  How to create a people graph in Excel? Create a People Graph in Excel Excel People Graph Using People Graph in Microsoft Excel  Add People Graph Add-in 1) Home ~ Add-ins 2) Search for "People" 3) Add 4) Reposition and resize 5) Left click on the "People Graph" 6) Data 7) "Select your data" button 8) Select your dataset (with header) 9) Create  Change Title 1) Left click on the "People Graph" 2) Data 3) Title  Setting For People Graph 1) Left click on the "People Graph" 2) Settings 3) Change theme 4) Change shapes  How to create a people graph in Excel?,Create a People Graph in Excel,Excel People Graph,Using People Graph in Microsoft Excel,  Check out my complete suite of Microsoft Excel Tips and Tricks. https://www.youtube.com/@jjnet247/shorts https://www.tiktok.com/@exceltips247 https://www.instagram.com/exceltips247/ https://www.dailymotion.com/ExcelTips247 https://www.pinterest.com/ExcelTips247/excel-tips-and-tricks/ https://x.com/ExcelTips247/media https://www.reddit.com/r/Excel247/ https://www.facebook.com/XyberneticsInc/reels/  #microsoft #excel #tips #tipsandtricks #microsoftexcel #accounting #fyp #fypシ #exceltips #exceltricks

Transcript

00:00if you really want to impress someone with the excel skill create this impressive looking people

00:05graph chart that looks something like this where it can be customized in various ways to convey

00:11your message and here's how you do it first you're going to click on the home from the ribbon

00:15and then click on add-ins on this add-in there's a search bar here you're going to type the

00:21word

00:21people and then you're going to install something called people graph click on add in here

00:27and after a few brief moment it will come up with a default people graph chart that looks something

00:32like this now to add your own data set into this graph chart left click on the graph chart click

00:39on

00:39this data icon here and then click on this select your data and now go ahead and select your data

00:45type like that and then after that this section should show you have selected 11 rows and two

00:51columns like mine here and then after that click on create and what that does is creates this

00:56people graph chart for you now you don't see all of the details in here what you have to do

01:02is

01:02basically resize and as well as reposition as well if you have too much data in here you can actually

01:09hold your control key and roll your center mouse wheel to resize your people graph chart so that all

01:16your rows of your data set can be displayed you can also change the title of this left click on

01:22this

01:22people graph chart here go back to your data and then in here you can change it to whatever title

01:29you like i'm going to call it sales technique survey and i'm going to close my data tab like this

01:35you can also modify the theme of your people graph chart and the icons that illustrate your data set

01:42left click on your people graph chart click on settings and click on themes here there's various

01:48themes that you can choose from i'm going to select this guy here and now to change the icon click

01:53on

01:53shapes and there's a few other shapes that you can select from this list here

How to create a people graph in Excel? - Excel Tips and Tricks

Category

Transcript

Comments

Recommended