![]() Use the growth function as explained above using CTRL+SHIFT+ENTER we will get a growth value figure with another line chart which is shown below in grey color. ![]() Now, this sales data shows only the trend figure with orange line show linear values, and the graph will be more dynamic if we put the month-wise growth value. ![]() So we get the line chart graph as given below where it shows very clearly sales data month wise. To view in graphical chart format, choose insert and select the line chart format. We are going to using the trend function here to get the result, select the column D41 to D56 and use the trend function as per below.Īfter selection, we use the Trend function by selecting C41: C56 and then we have to use CTRL+SHIFT ENTER to get the entire trend value shown below.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |