How To Add A Horizontal Line To A Chart In Excel - The Excel Hub
We cover how to add a horizontal line to a graph in Excel. In our example, we have the risk adjusted revenue of a credit card product and a forecast for comparison purposes. In order to better visualise whether the revenue was above or below forecast, we plot the forecast as a horizontal line. To do this, we first insert the chart and then format the horizontal line as a scatter chart with straight lines.
How To Add A Vertical Line To A Chart In Excel:
• How To Add A Vertical Line To A Chart...
Excel Charts Playlist:
• Excel Charts - The Excel Hub
Subscribe for weekly Excel tutorials, techniques and examples:
/ @theexcelhub
Please share this video with others that may find it useful:
• How To Add A Horizontal Line To A Cha...
Please comment below if you have any feedback or any suggestions for videos you would like us to upload next!
🌍 The Excel Hub website: https://theexcelhub.com/
📸 Instagram: / theexcelhub
ABOUT US:
The Excel Hub seeks to enhance your Excel and VBA knowledge by providing value-adding tutorials, techniques and examples in order to help you take your spreadsheet and data analysis skills to the next level.
For any enquiries, please contact:
[email protected]
Overview: (0:00)
Insert Chart: (0:42)
Add Horizontal Line: (1:13)