This is just like a line chart with colors. Let’s see how to create each of these and in which scenario which one should be used. There are three in-built types of area charts available in Excel: Now let’s see how to create an area chart in Excel and some examples where area charts can be useful. While it’s the same data, using an area chart, in this case, makes the overall contribution stands out. In the above chart, we can see that Printer B (represented by the orange color) has the maximum contribution to the overall sales. In case you’re only interested in showing the trend, using a line chart is a better choice (especially if the charts are to be printed).įor example, in the below case, you can use a line chart (instead of an area chart)Īrea charts are useful when you have multiple time series data and you also want to show the contribution of each data set to the whole.įor example, suppose I have three product lines of Printers (A, B, and C).Īnd I want to see how the sales have been in the past few years as well as which printer line has contributed how much to the overall sales, using an area chart is a better option. An area chart is similar to a line chart with one difference – the area below the line is filled with a color.īoth – a line chart and an area chart – show a trend over time.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |