how to add two trend lines in excel 2016

By default, Excel determines how to display the Sparkline data so with these options you can control the minimum and maximum values. From here, you can enter either the minimum or maximum value (depending upon which option you selected) for the vertical axis for your Sparkline data. If you click the Custom Value options in this drop-down, Excel opens the Sparkline Vertical Axis Setting dialog box.

From here, you can select the range in your workbook that contains the date values you want for your Sparkline data. If you click the Date Axis Type option in this drop-down, Excel opens the Sparkline Date Range dialog box. Show markers to highlight individual values in line sparklines.Ĭhange the style or format of sparklines. On the Style tab, pick the options you want. Select the sparklines you want to customize to show the Sparkline Tools on the ribbon. If you select one cell, you can always copy a sparkline to other cells in a column or row later by dragging or using Fill Down (Ctrl+D).Īfter you create sparklines, you can change their type, style, and format at any time. Use the Style tab to customize your sparklines.īecause a sparkline is embedded in a cell, any text you enter in the cell uses the sparkline as its background, as shown in the following example. The Sparkline Tools appear on the ribbon. If you’d rather select the range of cells on the worksheet, click to temporarily collapse the dialog box, select the cells on the worksheet, and then click to show the dialog box in full. In the Data Range box, enter the range of cells that has the data you want to show in the sparkline.įor example, if your data is in cells A, B, C, and D of row 2, enter A2:D2. On the Insert tab, in the Sparklines group, click Line, Column, or Win/Loss. Select a blank cell near the data you want to show in a sparkline. Showing trends in your worksheet data can be useful, especially when you’re sharing your data with other people.

Sparklines can draw attention to important items such as seasonal changes or economic cycles and highlight the maximum and minimum values in a different color.

Sparklines are tiny charts inside single worksheet cells that can be used to visually represent and show a trend in your data.

How to add two trend lines in excel 2016