![]() ![]() If I need to cover multiple sections and know the exact data values, it would not be feasible.Reading the exact values from this chart is not feasible.It is difficult to read as compared to other charts.It compares only a small number of categories.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. Right-click on Legend and select Format Legend. 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”. He wants to make an area chart so that the canteen owner can have quick visualization for the sales in the quarter.īelow is the representation of the raw data in excel, There is a canteen which sells the following products, the vendor has data of his sales for the month of Jan, Feb & March. ![]() In the above-mentioned chart, Y-axis is the representation of marks, whereas the X-axis is the representation of subjects. After that, you can find the fifth type of chart as “ AREA”. ![]()
0 Comments
Leave a Reply. |