The Scatter Chart, which is also known as the XY Chart, depicts relationship among items of different data series. In simple terms, it is a plot of X values and Y values along the two Axis. The data points are not connected and can be customized using different symbols. This chart type is normally used to represent scientific data, and can highlight the deviation of assembled data from predicted data or result.
To create the Scatter Chart, you can set the ChartType property to Scatter at design-time as well as run-time.
Set the Stacking property to Stacked or Stacked100pc to create the stacking Scatter Chart.
Suppose that there is an ABC Warehouse that deals in garments and accessories. The inventory department and the sales department of the warehouse try discerning the relationship between the profit earned and amount sold at specific sales amounts in 2013, 2014, and 2015. Apparently, they wish to put a specific limit at the quantity of items purchased at the beginning of a year to prevent the unsold items from getting tampered or wasted at the end of the year.
Let us use the Scatter Chart to depict the required relationship.
2013
Profit % | Sales Amount (Lakhs) |
---|---|
43 | 10 |
44 | 20 |
50 | 30 |
35 | 40 |
60 | 50 |
2014
Profit % | Sales Amount (Lakhs) |
---|---|
50 | 10 |
33 | 20 |
61 | 30 |
45 | 40 |
64 | 50 |
2015
Profit % | Sales Amount (Lakhs) |
---|---|
52 | 10 |
40 | 20 |
55 | 30 |
41 | 40 |
67 | 50 |
The above chart depicts the relationship between profit % and sales amount in three years.
Below is the code implementing the scenario: