Lesson#109: Tricks to make a dancing chart in excel

 Here I will show you funny trick to make a dancing chart in excel. For that you have to follow some steps. 1. Make a range of data names like A, B, C, D….. 2. Then put values against these names with RANDBETWEEN formula by putting any arbitrary lower and upper values.   3. Then…

Lesson#98: How to customize axis of chart

So I have discussed about creating a chart and what type data are suitable for what type of chart. Now I am going about detail discussion about the features and options behind chart. These are very important when you need to format your chart. This post is about how to customize axis of chart. Here I…

Lesson#97: Examples for column and bar chart

Here I will show you some examples for column chart and bar chart as well as. Column chart can be used to represent data or values graphically which are arranged in categories. Here we are having an whole year average temperature data for some cities. Making a column chart is very easy with it. You…

Lesson#96: How to HLOOKUP chart from a drop down menu in Excel

So here is another important lesson for you. How to HLOOKUP chart from a drop down menu in Excel? Here I am having a table. Table contents skill set data of six players. Here I will show you how to HLOOKUP the chart from there. First you have to make a drop down menu from…

Lesson#95: How to VLOOKUP chart from a drop down menu in Excel

So that’s an important lesson for you my dear. How to VLOOKUP chart from a drop down menu in Excel? Here I am having a table. Table contents skill set data of six players. Here I will show you how to VLOOKUP the chart from there. First you have to make a drop down menu…

Lesson#94: You can add many chart data in same area

Hi! Continuing with chart topic. In previous post I showed you to use a radar chart and for what type of data you can apply. Now I will show that you can add many chart data in same area. Previously we were having only one player skill set data with me. Now I have made…

Lesson#93: Radar chart example with Cristiano Ronaldo

Hi! I am back with one more interesting post. Here I will show you a chart example. Yes my friend charts are very very important things to know in Excel. Rather than wasting time let’s discuss about a Radar Chart example on the Cristiano Ronaldo’s skill set data which I found in FIFA video game…

Lesson#89: Example of bar chart with life expectancy data

Hello reader. This post is a discussion about an example of bar chart making with life expectancy data of all countries. Here I am having data in 4 columns. Country, Both sexes life expectancy, Female life expectancy, Male life expectancy. I will represent this data with help of a bar chart. In a different sheet you go…

Lesson#81: Making an automatic analog clock in excel with pie chart

Previously I had discussed about how to make an analog clock with piechart in excel. I am sharing the post link below. Lesson#61: Making a semi analog clock with pie chart Now I will add some simple VBA to make the clock auto refreshed every second. So I have taken these simple steps. 1. From…

Copyright 2017-2018@Excelabcd