![]() You now have a column chart of the actual units sold, with a trendline showing the trend. In the Chart editor, change the Chart type to Combo chart.Select all three columns, and then go to Insert.Google Sheets will now project the trend values. This will project Ys based on the trendline for the same Xs. ![]() Then again, it asks the TREND function to give new Ys based on the trendline for Xs A2 to A9.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |