It represents relatively simple data in a quantitative format.
The above image is a pictorial representation of the overall analysis of the employees for their respective quarters.Īlong with the various uses of the Area chart, there are some Pros and Cons to it. For example, in a Company A, B, C & D are working, and the boss wants to review their performance for the three quarters passed in this year.Īnd we follow the same steps and go to the insert tab and then in the chart section select all charts, We also learned that this chart could show overall or individual trends. Therefore, it is easier to look at the spending which Anand did for the past three months from the 3-D Area chart. The above image shows a clear picture of the data. In the Area chart, there is another choice for 3-D charts as well. No worries, the above chart is a 2-D or two-dimensional chart. Uh-oh, we cannot judge Anand’s spending for the past three months from this area chart. Example #2Īnand is a bachelor, and he wants to see what was his spending for the past three months in terms of Food, Rent, Electricity Bill, Travel Charges and Miscellaneous Expenses.īelow is the representation of raw data in excel,Īgain, follow the same steps and go to the insert tab and then in the chart section, select all charts. All the products are in a different colour from one another, and the area occupied by them shows the number of sales done. We have to click on Layout > Chart Title > Above Chart.Īs the definition follows, the chart distinguishes data in colours and textures. Right-click on Legend and select Format Legend.įor Adding chart title. Right-click on the Plot chart and click on select data.Īfter switching, the chart will look like this. Select the first one and then click OK.Īs soon as you insert the chart, it will look like this. Let’s follow the same steps and go to the insert tab and then in the chart section, select all charts.Īfter that, you can find the fifth type of chart as “AREA”. Below is the representation of the raw data in excel,
0 kommentar(er)
