Category: charts

Box & Whisker Plot Chart (How To:)

charts

Hi there,

 

In this post, we will look into a very challenging and interesting chart. The chart name is Box and Whisker Plot Chart. This chart will give the better understanding of the data in terms of visual presentation. Here I have a sales data for last 2 years and I want to showcase the maximum, minimum, average sales between two years.


Before I showcase the raw data, the required work around with raw data are: 

1. Find Min, Max, Median, Quartile1 and Quartile2 values. (using functions)

2. Find the values for Height of the Box and (using formulas)

3. Find the values for Whiskers (using calculations)


Now, the data looks like this.

Full story »

Awesome Charts for Sale!!!

charts

Hi there,


In this post, you will find an affiliate link for most awesome charts available in Excel 2013 and Excel 2016. We will see some of the awesome inbuilt charts available. These charts presents awesomeness to the data in terms of visualization. The awesomeness charts that are shown here are as follows.

 

Few Awesome Charts:

Full story »

New Charts Added in Excel 2016

charts, Excel 2016

Hi there,

 

Yes, you heard right. There are few charts added in the charting family (INSERT RIBBON) for Excel 2016. These charts are actually not new. Passionated Excel Users has already using them by adding few logics however, they are now in use by just giving a click of a button. Here is a quick tour to those new seven Excel charts. 




The detailed information about the above presentation is discussed here.

Full story »

DIMPLE on My Chart

charts

Hi there,

 

Genuine Online Shopping Cart
 

Do you like dimple?


Of-course, I like dimple on heroine's cheek.

 

Do You?

 

Of-course, you are. I know you like on heroine's cheek but I am asking in excel chart. :)

 

Fine, I will explain the problem and the solution about dimple chart using 4 pics. These four pics will conclude the post of today. 

Full story »

Custom Markers in Charts

Shortcuts, charts, mouse tricks

Hi there,

 

Genuine Online Shopping Cart


Have you ever used custom excel markers? If you haven’t, I am certain that, after reading this post you are going to use them the next time you create a chart with markers..!


As they say , “A picture is worth a thousand words! “, by telling your story with the help of pictures , in a jiffy you could grab the attention of your audience , who weren’t expecting anything more than a boring, pale markers!


If you are already customizing, please do teach us how you customize excel markers in the below comments section. Once you are done posting your comment, Follow this post and see How I did?


Let me take the old example itself, I have a list of courses where I trained through offline and online. And, I want to see them in a marker chart where excel icons should display below the numbers. So, here is the raw data

Full story »

Prepare a Chart in 5 Seconds

charts, CF

Hi there,

 

Hey!!! you know Excel chart can be prepared in 5 seconds. Of-course there are many ways where we can prepare/create charts in 5 seconds. Here, you will be learning how to prepare a simple chart using conditional formatting.

 

To begin with a chart first let me show you the raw data so that you can also prepare with out continuing with this post. Once you are done with the chart you can go through the post to check whether we are on the same page or better.

Full story »

Contact / Help. ©2019 by Abhilash VK. Design & icons by N.Design Studio. Skin by Tender Feelings / Evo Factory.