![]() ![]() This will open the Format Data Series pane, where you can choose the desired dash type, color, etc.įor more information, please see How to customize the line in Excel chart.įor me, the second method is a bit faster, so I will be using it for this example.Īdditionally, we will make our graph interactive with a scroll bar. Right click it and pick Change Series Chart Type in the pop-up menu.įor this, on the same tab of the Format Axis pane, expand the Labels node and set Label Position to None. Please notice that we use absolute cell references to ensure that the formula copies to a second cell without changes. You can also make the line thinner or thicker by changing its Width.ĭepending on your settings in steps 8 andĩ, it will look like one of these images. Otherwise, the selected x andor y cell will be added to the existing array, which will lead to an error.ĭepending on your needs, set Direction to one of the following. ![]() In this example, we are going to add a vertical average line to Excel chart, so we use the AVERAGE function to find the average of x and y values like shown in the screenshot. You will also learn how to make a vertical line interactive with a scroll bar.īut there is still no easy way to draw a vertical line in Excel graph. I have been pulling my hair out trying to put todays date on a horizontal bar chart I use as a project plan and after browsing multiple sites I only found this article to demonstrate the solution without impacting the format of my existing chart. Then select Axis Titles Primary Horizontal Axis Title Title Below Axis. However, we still need to set up a secondary Y-axis as Series 2 is currently using the primary Y-axis to display its data. One more complication to this example is that our data is not all in adjacent cells, so we need to select columns A, C, and E separated by commas. In this example, we want column A to represent our X-axis and column C to represent our primary Y-axis (left side) and column E to represent our secondary Y-axis (right side). How To Add A Secondary Axis In Excel 2008 For Mac By dechacentga1985 Follow | PublicĪdd A Secondary Axis In Excel 2008 Free To Download ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
January 2023
Categories |