Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Attached is an excel file to accompany the guide (you will see the various steps outlined in the excel chart)

Adding_horizontal_line.xlsx

Step-by-step guide

This confluence page is based off the following website: http://peltiertech.com/Excel/Charts/DummySeries.html#AddLine

...

10. Right click the secondary X axes and select format axis

         a. Change the maximum bound from 1.2 to 1.0

         b. Click on Tick marks and change major and minor type to None

         c. Click on labels and change label position to None

11. Right click the secondary Y-axis and delete it. The target value should now move to its appropriate place in the chart

 

Image Added

 

12. For more information on adding lines to charts, please see the following website 

 http://peltiertech.com/Excel/Charts/DummySeries.html#AddLine

 

 

 

 

 

 

 

 

 

 

Info

Content by Label
showLabelsfalse
max5
spacescommcarepublic
sortmodified
showSpacefalse
reversetrue
typepage
labelsExcel Dashboards