- Adding Sparklines to a Worksheet
- Understanding the Axis Size of Sparklines
- Creating Column Sparklines for High Temperature Data
- Forcing Each Sparkline to Have the Same Scale
- Adding Labels and Shading the Normal Range on a Sparkline
- Adding a Reference Line
- Adding Shading to Show the Normal Range
- Showing Negative Values
- Win/Loss Sparklines
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:
- Copy your original data and paste it to a blank section of the worksheet.
- Temporarily change Miami January to 32. Change Curitiba December to 32. This will give you a guide when drawing the line.
- Consider using the zoom slider in the lower right to increase the zoom to 200% to help you position the line correctly.
- Select Insert, Shapes, Line.
- 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.
- 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.
- Don't forget to replace the temporary 32 values in Miami and Curitiba with the correct original values.