␡
- 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
Like this article? We recommend
Adding Shading to Show the Normal Range
Like this article? We recommend
Like this article? We recommend
Like this article? We recommend
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.
){kind=small}
){kind=small}
)
){kind=small}