US 1.877.212326.2662
Browse Search
HOWTO: Displaying Multiple Data Series in Chart Plus Web Part
Created on: 29-Sep-07. Print Article
Last Modified on: 12-Jan-11. Email Article
Article has been viewed: 11191 times.
Rated: 8 out of 10 based on 6 votes.
KB.10756
APPLIES TO:
  • WSS 3.0 and MOSS 2007
  • SharePoint Foundation 2010 and SharePoint Server 2010

There are many situations where you want to display multiple sets of data on the same chart.  There are also cases where the series data uses different scales and thus you want to be able to provide different series axes to further differentiate the data.  This use case addresses how the Chart Plus Web Part handles the display of multiple data series and multiple axes.

 

 

Using the sample data as shown above, we want to be able to produce a chart that contains multiple series.  The series display the sales units in the US, sales units in the international market and the total sales units.  We also want to display the revenue number for each region.  The revenue numbers are using a different scale (30,000 to 100,000) from the unit sales (20 to 630) and we want to use a different Y-Axis to maintain the visibility, but display all the series in the same chart.

 

 

To create this chart:

 

1.       Select the same Chart Type for each column to be displayed in the series. In this example, the user selects Bar as the Chart Type for both US Count and World Count columns.

2.       Select the Total Count and the Revenue using a different chart type to denote the difference.  In this case we will use the Line chart.

3.       Assign ONE of the series to use the Secondary Y-Axis. In this example, the user selects the Revenue column to display on the Secondary Y-Axis.

 

The above settings display your total Sales per Category with a series of information as Bar charts and the second series of information as Line charts:

 

 

Related Articles
Q10734 - HOWTO: Chart Plus Web Part Overview
Q10755 - HOWTO: Using Ungrouped Data Operators with the Chart Plus Web Part

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help Us Improve This Article
What did you think of this article?

poor 
1
2
3
4
5
6
7
8
9
10

 excellent
Tell us why you rated the content this way. (optional)
   
Approved Comments
No user comments available for this article.