- 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: