Wednesday, July 3, 2019

SSRS - How to add a Scatter Plot in Report

Scatter Plot in SSRS is useful to visualize the relationship between any two sets of data. Scatter plots or bubble charts are commonly used for displaying and comparing numeric values, such as scientific, statistical, and engineering data.    
  1. A scatter chart displays a series as a set of points.   
  2. Values are represented by the position of the points on the chart.
  3. Categories are represented by different markers on the chart.
  4. Used to compare aggregated data across categories. 

Why Scatter Plot OR Bubble Charts Reports?
  • Use the scatter chart when you want to compare large numbers of data points without regard to time. The more data that you include in a scatter chart, the better the comparisons that you can make.
  • The bubble chart requires two values (top and bottom) per data point.
  • Scatter charts are ideal for handling the distribution of values and clusters of data points. This is the best chart type if your data-set contains many points (for example, several thousand points).
  • Displaying multiple series on a point chart is visually distracting and should be avoided. In this scenario, consider using a line chart. By default, scatter charts display data points as circles. If you have multiple series on a scatter chart, consider changing the marker shape of each point to be square, triangle, diamond, or another shape.
We will learn-
  1. How to create a Scatter Plot/Bubble Chart
  2. How to change the Chart Title, Legend Position, Legend Title, and Font style
  3. How to change marker shapes on the chart 
  4. How to add Tool-tips text on the markers
To watch a demo, please visit our YouTube channel-

No comments:

Post a Comment