How do i change the series name on a scatter chart excel

HOW DO I CHANGE THE SERIES NAME ON A SCATTER CHART EXCEL HOW TO

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 When you first create a chart in Excel 2013, the result might appear confusing - with some chart types, most notably line charts, Excel displays the X axis as '1, 2, 3.' regardless of the data. 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.Based on the type of data, you can create a chart. The name you type appears in the chart legend, but wont be added to the worksheet. Excel Charts - Types, Excel provides you different types of charts that suit your purpose. In the Series name box, type the name you want to use. In the Select Data Source dialog box, under Legend Entries (Series), select the data series, and click Edit. In the Edit Series box, create a new data series: Under Series name, highlight the corresponding header row cell (B1). Right-click the chart with the data series you want to rename, and click Select Data. In the Select Data Source dialog window, click Add. Click on the empty chart and go to Design вЂ“> Select Data. Right-click on the empty chart and choose Select Data from the contextual menu.Go to Insert вЂ“> Charts вЂ“> Scatter Chart.Chart Studio is the easiest and fastest way to make and share graphs online.

HOW DO I CHANGE THE SERIES NAME ON A SCATTER CHART EXCEL HOW TO

Other Excel tutorials you may also like: A tutorial on how to make a scatter plot on a map with Chart Studio and Excel.2.2 вЂ“ Extracting the Values for the Selected Company.2.1 вЂ“ Create a Drop Down List with Company (data point) Names.

How do i change the series name on a scatter chart excel