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 kommentar(er)
