A second column chart will be displayed beside the first chart. Adding the series name and valuesįigure 7. In Series values, select D3:D7 or input =column!$D$3:$D$7.In Series name, select cell D2 or “Passing Rate”.The Select Data Source dialog box will pop-up.Right-click anywhere on the existing chart and click Select Dataįigure 3.In order to add a horizontal line in an Excel chart, we follow these steps: We want to add a line that represents the target rating of 80 over the bar graph. How to add a horizontal line in an Excel bar graph ? Click Insert tab, Other Charts, then All Chart TypesĪ column chart will be created, showing the rating per corresponding class.įigure 2.Suppose we have below data and we insert a column chart using the data in B2:C7. How to add a horizontal line in an Excel scatter plot?.How to add a horizontal line in an Excel bar graph ?. This step by step tutorial will assist all levels of Excel users in the following: When we want to compare actual values versus a target value, we might need to add a line to a bar chart or draw a line on an existing Excel graph. Excel allows us to simply structure our data.according to the content and purpose of the presentation.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |