SharePoint components - business processes without development, InfoPath, SharePoint Designer or workflows. SharePoint Services, SharePoint Foundation & SharePoint Server 2010-2016.

Training

Range Column Chart

A Range Column chart is useful in comparing many series of data side by side. WIth this chart, changing the 3D setting has a distinctyly different effect.

In this example, we compare the spending between departments on a year to year basis:

Instructions

  • Begin by creating a new list that is appropriate for the chart type.
  • Create a list called Deparmental Spending.
  • Change the Title column to Year.
  • Add currency columns for Sales, Marketing, Accounting, Development, Customer Support and Administration.
  • Add test data as shown:

  • Create a new page Departental Spending Chart.
  • Add a Smart Chart web part as described in the Column Chart section.
  • Use a large size of 500px height and 700px width.
  • Choose the Range Column Chart type as shown.
  • Include each of the departments as a series in the chart.

  • Your chart output will look similar to above.
  • Try turning on the 3D setting for a dramatically different chart.

Summary

Range Column is a good choice when examining the values for many fields in a list over time. Making use of the 3D settings produces a dramatically different chart.

Last modified: 8/24/2015 8:11 PM
Be the first to add a comment to this article
 
Comments are not designed to replace support calls. If you have a specific issue with one of our products, please send an email to support@infowisesolutions.com to open a support ticket.