Cell B25 would change whenever I change the drop down selection.For example, in this case, the drop down is in F3, and in B25 I have the formula =F3. Select a cell and refer it to the cell with the drop down.In the Data Validation dialogue box, select List (as validation criteria) and select the entire range that has names of the companies (in this case, the list is in B3:B22), and click OK.Ģ.2 – Extracting the Values for the Selected Company.Go to a cell where you want to create the drop down.This has 3 parts to it: 2.1 – Create a Drop Down List with Company (data point) Names Now comes the interesting part – creating the marker to spot your selected company. This will create a simple scatter chart for you. In the Edit Series dialogue box, select the range for X axis and Y axis.In the Select Data Source dialogue box, click on Add.Click on the empty chart and go to Design –> Select Data.Go to Insert –> Charts –> Scatter Chart.Other Excel tutorials you may also like:.2.2 – Extracting the Values for the Selected Company.2.1 – Create a Drop Down List with Company (data point) Names.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |