Category: Charts
How to Create an Excel Funnel Chart
If you work in sales, marketing or any department that uses/receives reports from Business Intelligence software, you're probably familiar with the Sales Funnel Chart. If you are looking to create a funnel chart of your own, you might find that it's a bit of a trick. Excel gives you the…
Read More
Create Outstanding Pie Charts in Excel
Once you have gone to the effort of collecting, organizing and processing your data, you probably want to show it off! Tables do a nice job of presenting raw information, but a chart can bring your data to life. Charts create visual impact that conveys not only the data itself,…
Read More
Microsoft Quick Tip: Visualize Your Data in an Excel Bubble Chart
Microsoft opened the door additional functionality through apps in Office 2013. If you want to create visual impact for your data in charts and graphics, there are numerous apps or add-ins to meet your need. For more on add-ins, check out our post: Three Excel Chart Add-Ins to Create Unique Charts…
Read More
Creating a Graph with Mutiple Data Series in Excel Without a PivotChart
One of the most powerful advantages of a chart is its ability to show comparisons between data series, but you'll need to spend a little time thinking about what you want to show and how to organize it for excellent communication. Let's look at the ways that Excel can display…
Read More
Three Excel Chart Add-Ins to Create Unique Charts and Graphics
There's no debating that Excel is a powerful, useful tool for gathering, analyzing and communicating all kinds of data. But even the biggest fan sometimes wishes for just a little bit more, especially when you want to create visual impact for your data in charts and graphics. Microsoft opened the…
Read More
Creating a Radar Chart in Excel
Sometimes it is very useful to see the magnitude of many variables for several different independent variables in one chart. The easiest way to do this is to create a radar chart, also known as a spider chart or web chart in Excel. A radar chart in Excel is set…
Read More
How to Make a Pareto Chart in Excel
The Pareto Principle, named for Italian economist Vilfredo Pareto, suggests that 80% of problems can be traced to as few as 20% of root causes. This can be valuable, even vital information when you are trying to figure out which of many problems to tackle first, or in a complicated…
Read More
How to Use Excel Chart Templates
How often do you need to insert a favorite chart style, consistent with your prior submission, to maintain a consistent look and feel to your monthly reporting packages? That consistency is one element that increases the appearance of professionalism—especially if it reflects your company’s brand, typography, and color scheme. The…
Read More
Creating a Flowchart in Excel
Have you been tasked with creating a flowchart to document a business process? Some companies invest in expensive, specialized software that builds flowcharts for you with just a few points and clicks. Other businesses prefer to use a tool which they already have, and in which the employees have already…
Read More