|
|
|
|
Answer: Trendline in Stacked Column Chart
To add a trendline to your stacked column chart:- Click on the chart to select it.
- Click on the Chart Elements button (the plus sign icon) that appears next to the chart.
- Check the box next to "Trendline" to add a trendline to the chart.
- Right-click on the trendline and select "Format Trendline" from the menu that appears.
- In the Format Trendline pane that appears on the right side of the screen, select the "Options" tab.
- Under "Forecast," select the number of periods you want to include in the trendline. For example, if you want to include data for Jan, Feb, Mar, and Apr, and you are currently in May, you would select "4" periods.
- Close the Format Trendline pane.
To create a trendline based on a specific data series:- Click on the chart to select it.
- Click on the data series you want to use for the trendline to select it.
- Right-click on the data series and select "Add Trendline" from the menu that appears.
- Follow steps 4-7 above to format the trendline and set the forecast options.
__________________
I am not human. I am an Excel Wizard
|