Hello reader. This post is a discussion about an example of a 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 …
Lesson#89: Example of a bar chart with life expectancy data Read more →
Previously I had discussed 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 a pie chart Now I will add some simple VBA to make the …
Lesson#81: Making an automatic analog clock in excel with a pie chart Read more →
Here I will show how to make a Sine curve but before that, we have to learn two functions SIN and RADIANS. What is the function of SIN? SIN returns the sine of degree which is given in radian format …
OK friends! How is everyone? Now in this post, we will learn an unusual trick to make a semi-analog clock with Pie Chart. Let’s see. First I have made a 3X3 table for the hour, minute, and second of the …
Lesson#61: Making a semi analog clock with pie chart Read more →
Here I have gathered 100 year’s precipitation and average temperature data from www.indiawaterportal.org. For example, I have chosen the city Nagpur which is in the state of India, Maharashtra. I have a column beside the precipitation data to make the …
PivotTable has very powerful features to analyze data. One of them is PivotChart. PivotChart is a different feature of Pivot Tools to represent the PivotTable data with the chart. Here I am having a practice with the employee database and …
In this post, I will discuss some examples where Pie Chart is applicable. Pie Chart is generally used to show percentage or proportional data. Here I have downloaded a mutual fund portfolio allocation data sector-wise in the stock market. I …
Lesson#55: Some examples where Pie Chart can be used Read more →
Let’s have some charting practice in excel. I have downloaded last month’s INFOSYS stock data from the National Stock Exchange website in CSV format. Now I will go to Insert>Charts>Other Charts>Stock>Volume-Open-High-Low-Close It shows a message box that the data should …