Charts are used to convert the numeric data in a graphical format. Its useful to analyze the data. It makes it easier to understand large amount of data and the association between different series.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.Let's take an example:-We have sales performance data, in which we have the agents name and the amount of achieved sales.
![]()
To insert a horizontal average line in the Chart follow the below given steps:-. Select the range of data, go to the insert tab, click on column chart, click on 2D chart. After inserting the chart two contextual tabs will appearnamely, “Design” and “Format”. From the “Design” tab choosethe “Chart Style”. To add the reference line in the chart you need to return the average of sales amount. Write the average formula in data cell C6 =AVERAGE ($B$6:$B$15).
The function will return 5.95. Select the chart area the data will get highlighted in a blue color line, drag it till the end of the data. Another way to add the data in the chart, go back & click on the chart. 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.Conclusion:- Now you can see the average line in the above chart which is clearly showing agents whose performance is above and below the target.If you liked our blogs, share it with your friends on. And also you can follow us on and.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. Write us at [email protected].
![]() ![]()
MS Excel is MS Office application packages’ spreadsheet editor. MS Excel is one of the most commonly used applications for handling data spread-sheets. The Excel spread sheets are the documents that you will sooner or later switch into, for your domestic, office or organization’s use. This miraculous program has many mathematical, statistical, and sorting functions that can be implemented on the spread sheets, and in turn processes the data to arrange them according to any desired format and category.MS Excel also has some features and functionalities that are quite useful when implemented in the spread-sheet document. The program has some really efficient formatting and orientation options that can make the document easy for editing and viewing.
Am new to Mac and running Excel for Mac 2011. When I copy a sheet, or even copy / paste a cell within a sheet, a diagonal line (top left to. Add or remove border upward diagonal. Windows shortcut. On Windows, this shortcut only works within the Format Cells dialog box, on the Borders tab. 222 Excel Shortcuts for Windows and Mac. Related videos. The videos below demonstrate this shortcut. Shortcuts for borders. In this lesson, we look at the shortcuts you can use when.
All you need to have is proper information and knowledge to do so.Suppose you want to align a text diagonally facing the north-east direction. You may want to do so in order to allow the document to give a more organized and managed look and feel.If you wish to align the document diagonally, you must follow the below given instructions to do so.■Initialize the MS Excel program using any account.■Open the target spread sheet.■On the sheet, select the text of row(s)/column(s) that is to be aligned diagonally.■Upon selection, in the Alignment section of the ribbon, click the Orientation button.■From the drop-down that appears, you can select either Rotate Text UP or Rotate Text Down.
![]() Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
January 2023
Categories |