Since CSAT scores are commonly expressed as a percentage scale, consider the following table: For the record, this article is based on the tutorial created by Jon Peltier.
#Datagraph polar how to#
In this in-depth, step-by-step tutorial, you will learn how to turn your raw data into a polar plot in Excel from the ground up. Also, don’t forget to check out the Chart Creator Add-In, a powerful tool for building mind-blowing advanced Excel charts and graphs in just a few clicks.
The plot enables you to quickly assess the good and bad months for each company, which facilitates better decision making.Įxcel doesn’t support this chart type-in fact, it can’t even read polar coordinates-meaning you will have to build it from scratch. The polar plot comes in handy when the analyzed data has a cyclical nature.Īs an example, the chart below compares the customer satisfaction scores (CSAT), a metric that illustrates a customer’s satisfaction with a brand or product, of two organizations throughout 2019: Simpson Ltd and Griffin Ltd.
The plane itself is made up of concentric circles expanding outward from the origin, or the pole-hence the name.
0 kommentar(er)
