Note: If you have a lot of data points, your highlighter may get hidden behind the data points. Now you can select a company and it would circle and highlight the company. Marker Line Style –> Width (Make it 1 or higher).Marker Line Color –> Solid Line (Red or whatever color you want).Select Marker Option –> Built-in –> Type (select circular shape and increase the size to 11).Select that data point, right click and select Format Data Series. There would be a data point in a color and shape different from the other data points.In the Select Data Source dialogue box, Click Add.Select the already created scatter chart.In cell D25, use the VLOOKUP formula to extract the Profit Margin (Y axis) value for the company in cell B25:.In cell C25, use the VLOOKUP formula to extract the Revenue (X axis) value for the company in cell B25:.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.
#SCATTER CHART EXCEL POINT STYLE SERIES#
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.Select the Data Labels box and choose where to position the label. Here's how: Click on the highlighted data point to select it. Go to Insert –> Charts –> Scatter Chart. To let your users know which exactly data point is highlighted in your scatter chart, you can add a label to it.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 kommentar(er)
