Home > Articles > Home & Office Computing > Microsoft Applications

  • Print
  • + Share This
From the author of Adding a Reference Line

Adding a Reference Line

The temperature chart above has a white dashed line at the freezing mark of 32 degrees. This is created using the Insert Shapes command in Excel. Follow these steps to help draw the line:

  1. Copy your original data and paste it to a blank section of the worksheet.
  2. Temporarily change Miami January to 32. Change Curitiba December to 32. This will give you a guide when drawing the line.
  3. Consider using the zoom slider in the lower right to increase the zoom to 200% to help you position the line correctly.
  4. Select Insert, Shapes, Line.
  5. Hold down the Shift key to ensure that the line is straight. Draw a line using the temporary 32 values in Miami and Curitiba as a guide.
  6. While the line is selected, use the Drawing Tools Format ribbon tab. Use the Shape Outline drop-down to change three settings. Choose a new color from the top. Choose a Line Weight from the bottom.
  7. Don't forget to replace the temporary 32 values in Miami and Curitiba with the correct original values.
  • + Share This
  • 🔖 Save To Your Account