- 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 Shading to Show the Normal Range
The steps for adding a band of shading are similar to adding a reference line. Follow these steps:
- Copy your original data and paste it to a blank section of the worksheet.
- Temporarily change the first sparkline to have a value at the bottom of the normal range. This will give you a guide when drawing the rectangle. Change the last sparkline to have a value at the top of the normal range.
- 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, Rectangle.
- Draw a rectangle using the first and last sparkline as a guide.
- While the rectangle is selected, use the Drawing Tools Format ribbon tab. Use the Shape Outline drop-down to choose No Outline. Use the Shape Fill drop-down to choose a new fill color. You still won't be able to see through the rectangle.
- Press Ctrl+1 or use the Shape Styles dialog launcher to access the Format Shape dialog box. This dialog offers a transparency slider. Increase the transparency to about 75%. Close the dialog box.
- Copy the original data values back to the original data.