Excel Productivity Guide
Useful Excel Tips | Keyboard Shortcuts | VBA Codes
Download this Free E-Book to take your excel skills to a whole next level using some smart Excel tactics.
Worth $20, Absolutely Free
Category Archives for Charts
Add Vertical Line in a Chart
Sometimes while presenting data with an Excel chart we need to highlight a specific point to get user’s attention there.And, the best way for this is to add a vertical line to a chart.Yes, you heard it right.You can highlight a specific point on a chart with a vertical line. Just look at the below […]
➲ Continue ReadingHow to Add a Horizontal Line in a Chart
While creating a chart in Excel, you can use a horizontal line as a target line or an average line.It helps you to compare achievement with the target you want to meet or an average you need to maintain.Let’s say you have an average value which you want to maintain in your sales throughout the […]
➲ Continue ReadingMilestone Chart in Excel [Timeline]
Tracking all the steps of a project is an important task. It’s as important as the execution of the each step. In fact, tracking makes execution easy.And, if you are searching for a perfect chart template in which you can track your project in the simplest way, Milestone Chart should be your first choice.The basic […]
➲ Continue ReadingHow to Insert a People Graph in Excel [Step by Step]
I have been always fascinated about info-graphics and story-based visuals. These kinds of things help me to tell a story with data.A pictograph is a great example of this. But apart from this, there is a chart in Excel about which most of us are not aware.That’s called: People GraphIt was first introduced with Microsoft […]
➲ Continue ReadingHow to Create a Sales Funnel Chart in Excel
In this real world, everything has a process and to make that process successful we need to track each and every stage of it.Take an example of the sales.Let’s imagine, you are a sales manager and your most important KRA is to create new business. And, you have a sales process with different stages for […]
➲ Continue Reading