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

How To Create In Cell Bar Chart With REPT Function

how to create an bar chart with rept function featured image

In-cell charts are awesome. And today, I’ll show you how to create an in-cell bar chart with rept function. But, do they really worth your time? Yes. Here is the single important reason. They are easy to create and simple to use. Ahead, in this post, I’ll show a step by step process to create a […]

Check it out now

Dynamic Chart Title

Dynamic Chart Title In Excel

We all love dynamic and interactive charts. They are awesome.But, do you know what is the most important part of a dynamic chart?That’s ==> Chart TitleA dynamic chart title in excel is must to have to make charts interactive.Just think this way:You have created a dynamic chart in which values will change when current year […]

Check it out now

Create a Bullet Chart In Excel

how to create a bullet chart in excel step by step guide featured image

Selecting a right kind of a chart is one of the toughest tasks.While struggling with these kinds of problems, I’ve found a chart called “Bullet Chart”.Bullet Chart is one of those advanced Excel charts which you should learn to get better at charting.It’s a perfect chart to use when you need to present single point […]

Check it out now

10 Excel Charting Tips You Are Still Not Using

10 charting tips in excel you are not using featured image

The moment you are reading this post you still have to explore a lot of things about excel charts unless you are “Jon Peltier“. Here in this post, I’ll show you 10 charting tips which you can instantly use while creating your next chart. I’m pretty sure that these charting tips will help you to […]

Check it out now

Tornado Chart

how to create tornado chart in excel using this step by step guide featured image

Tornado chart is useful for those who want to analyze their data for better decision making. It’s a useful tool for sensitivity analysis, but you can use it for comparison purpose as well.It’s like a two-sided bar chart (looks like a tornado) where we have two data bars opposite to each other. It makes it […]

Check it out now