Make sure that all the cells have the same values. Write this formula in the first cell of the average column and drag it down. So the formula in the average column will be: =AVERAGE($B$2:$B$7) And the third column will have the points where the sales are less than the average. ![]() The second helper column will have all the points where sales are larger than the average. First helper columns will have average data. To make such a chart, we will need three helper columns. I want to visualize this data into a chart. Here I have some data that tells the total sales done by individual salesmen. The best way to learn is to learn by example. Highlight Area When Line is Above and Below the Average ![]() ![]() So how do we make this chart that highlights the area when the line is above or below the average? Let's learn it step by step. To visually see when the line on the chart is above or below the average of the series, we can simply insert an average line on the chart.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |