![]() In cell E5, I have mentioned the formula: If the cell C1 (scrollbar linked cell) is greater than or equal to 1, I want the value from cell B2 (that contains Jan month sales). I am applying the IF formula to rearrange the data. Step 5: Now, we need to rearrange the data to create a chart. Now you can check by clicking on the scroll bar. ![]() If I click on the scroll bar once in cell C1 the value will be 1 if I click on the scroll bar twice, it will show the value as 2 because it is incremented by 1. Incremental Change: This is once you click on the ScrollBar, what is the incremental value you need to give.Ĭell link: This is the link given to a cell. I have chosen 12 because I have only 12 months of data to present. ![]() Maximum Value: This is the highest value to mention.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |