We use cookies to give you the best online experience. By using our website you agree to our use of cookies in accordance with our cookie policy.

croom new

Preferred Blog

Preferred has been serving the Tinley Park area since 1991, providing IT Support such as technical helpdesk support, computer support, and consulting to small and medium-sized businesses.

Tip of the Week: Using People Graph in Microsoft Excel

Tip of the Week: Using People Graph in Microsoft Excel

Microsoft Excel is a great way for data to be visualized, particularly as it offers various features to highlight the context of the data you’re trying to communicate with. Today, we wanted to walk you through how you can use one such feature—People Graphs—to do so particularly impactfully.

What are People Graphs?

People Graphs are a Microsoft Office Add-In that allows you to create a quick data visualization. While the default icon included in the People Graphs is, predictably, a person, the graphs can be customized to display different icons—from a star, a heart, a clock, a bag of money or various others.

Let’s go over how you can create these simple graphs to present simple data points to your advantage.

Creating a People Graph

First, you need to have the data you want your People Graph to depict in your spreadsheet. Let’s assume that you wanted to share some statistics concerning the work/life balance habits of today’s workers. In one column, list out the stats you want to share, and in the next, list out the numerical values associated with these statistics.

Select this data range. Then, in the Insert toolbar, select People Graph under Add-Ins. A premade graph will appear on your sheet. Select the Settings option, which will appear in the top-right corner when you click on the graph.

From there, you can customize what your graph looks like, its color scheme, and the shape of the icon itself.

Once you’re pleased with the appearance of your graph, you can then select the grid button that appears next to the settings option. From there, you can customize the title and select the data that your graph pulls from.

Once you’ve selected the data, click Create, and your People Graph is complete.

Hopefully, you find plenty of use out of this capability!

Why You Might Consider Taking Your Security to the...
Looking at the Benefits of Cloud vs. Onsite Storag...
 

Comments

No comments made yet. Be the first to submit a comment
Guest
Already Registered? Login Here
Guest
Wednesday, July 24 2024

Captcha Image

Sign Up for Our Newsletter

  • First Name *
  • Last Name *

      Mobile? Grab this Article!

      Qr Code

      Blog Archive

      Latest Blog Entry

      In the wake of Hurricane Beryl, businesses have another reason to reflect on data backup, disaster recovery, and business continuity. Since the hurricane made landfall in Texas, despite being downgraded to a tropical storm, it still caused over $5 million in damage to island...

      Latest News

      Best Places to Work - 5 YEARS STRONG!!

      Preferred is once again, honored for being a Best Place to Work for the fifth straight year!  Our team is what makes Preferred a Best Place to Work.  

      Daily Herald Suburban Business 2024 Best Places to Work Honorees The Daily Herald Suburban Business has announced the names of 51 companies, in 5 categories of competition, that are honored as the 2024 Best Places to Work in Illinois. This statewide survey and awards program was designed to identify, recognize and honor the best places of employment in Illinois, benefiting the state's economy, its workforce and businesses.