Create scatter chart in excel vba how to#
Here we discuss how to create a Scatter Chart in excel along with excel examples and a downloadable excel template.This Excel tutorial explains how to ordinal data (text) in scatter chart using bar chart. This has been a guide to Scatter Chart in Excel. We cannot apply the scatter chart with only one values where it needs both X and Y values to display the chart in excel.While using a scatter chart, always use X and Y values with correctly or else we will not get the exact chart.In the above screenshot, we can see the scatter chart with a straight line and markers which shows ups and down where international sales are high at 177 for the product “Philips Avent Soft Spout Cup Deco (Green)” and National sales is high at 233 for the product “Philips Avent Fast Flow Spout Cup Deco (Green)” Things to Remember Once we click on the scatter chart with straight lines and markers, we will get the below result as shown below. Step 2 – Now go to the Insert menu and select the Scatter with straight lines and markers as shown below. Step 1 – First, select the entire column cell A, B, and C named Product Title, National and International. Here we can compare the sales by using the scatter chart with straight lines and markers by following the below steps. This example shows how to apply an excel Scatter chart with a straight line and markers with the below example.Ĭonsider the below figure, which shows sales data National and International wise. In the below result, we can see that scatter chart with smooth lines which shows the comparison result for the zonal and national wise sales.Īs we can check from the above screenshot, the Zonal and National Sales lines merges exactly with the Zonal sales values as 316 and National as 312, shown below.Įxample #4 – Using Scatter Chart with Straight Lines and Markers Once we click on the scatter chart with smooth lined, we will get the below output chart as shown below. Step 2 – Now go to the Insert menu and select Scatter chart with smooth lines as shown below. Step 1 – First, select the entire column cell A, B and C named as Product Title, Zonal and National as shown below. In this example, we will see how to apply the excel scatter chart with lines using the below example.Ĭonsider the below sales dump data which shows sales value Zonal and National wise.īy using the above figure, we can compare the sales for Zonal and National using the scatter chart with smooth lines by following the below steps. Example #3 – Using Scatter Chart with smooth Lines In the below scatter chart, we can easily compare the sales figure, which shows up’s and downs depending on the sales value.Īlso, we can check the scatter chart by placing the cursor on the dots so that excel will display the X and Y values, as shown below.Īs we can see in the above screenshot, the local and zonal sales values are almost close to the product name “Braun ES2 Hair Straightener”, which shows the dotted lined with exact merge as shown above. Once we select the specific chart, we will get the below output result as shown below. Step 4 – Click on the second scatter chart called Scatter with smooth lines and markers. Step 3 – Click on the down arrow so that we will get a list of scatter chart as shown below. Step 2 – Now go to the Insert menu and select the Scatter chart as shown below. Step 1 – First, select the entire column cell A, B, and Product Title, Local and Zonal, as shown below. In such a case, we can use excel scatter chat which will give us the exact result to compare it, and we can apply the Scatter Chart with Smooth Lines and Markers by following the below steps. Consider the below example, which shows sales value with local and zonal.Īssume that we need to compare the sales of local and zonal locations. This example shows how to apply the scatter chart with a smooth line and markers. Example #2 – Using Scatter Chart with Smooth Lines and Markers For example, the X value 38.43 exactly lies with the Y value 3.14. We can see that X and Y values lie between the exact figure with dots in the above result. So that the selected numeric values will get displayed in markers as shown in the below result. Step 4 – Next, select the first option, which shows Scatter with only Markers. Step 3 – Click on the down arrow so that we will get the list of scatter chart list which is shown below. Step 2 – Go to the Insert menu and select the Scatter Chart. Step 1 – First, select the X and Y columns as shown below. To apply the scatter chart by using the above figure, follow the below-mentioned steps as follows. Consider the below table, which has random X and Y values as shown below.
0 kommentar(er)
