Quietly hiding himself high in a tree, Ali Baba watches the thieves, loaded with glittering gold and shiny jewels, as they say the magic words “open sesame”. But this is no ordinary cave, as it only opens when the secret magic words are uttered. They have come to hide their treasure in a secret cave. We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you.Do you remember the story of Ali Baba and the 40 thieves? The poor woodcutter Ali Baba is in the forest one day collecting firewood, when he overhears a group of 40 thieves. And also you can follow us on Twitter and Facebook. If you liked our blogs, share it with your friends on Facebook.
Right click on the mouse then click on Select data you’ll see that the window will open, select the data source, click on chart data range select your data range and click ok.Ĭonclusion:- Now you can see the average line in the above chart which is clearly showing agents whose performance is above and below the target.Another way to add the data in the chart, go back & click on the chart.
Select the chart area the data will get highlighted in a blue color line, drag it till the end of the data.Write the average formula in data cell C6 =AVERAGE ($B$6:$B$15).To add the reference line in the chart you need to return the average of sales amount.From the “Design” tab choosethe “Chart Style”.After inserting the chart two contextual tabs will appearnamely, “Design” and “Format”.
Select the range of data, go to the insert tab, click on column chart, click on 2D chart.To insert a horizontal average line in the Chart follow the below given steps:. We have sales performance data, in which we have the agents name and the amount of achieved sales. In Microsoft Excel, when we want to present a chart to analyze the movement of data, we need to add a reference line, so that we can easily understand how the performance is & where there needs to be improvement.Let’s take an example and understand how you can add a reference line to a chart. It makes it easier to understand large amount of data and the association between different series. Charts are used to convert the numeric data in a graphical format.
0 kommentar(er)
