Column Chart Type

Labels
AJAX(112) App Studio(7) Apple(1) Application Builder(245) Application Factory(207) ASP.NET(95) ASP.NET 3.5(45) ASP.NET Code Generator(72) ASP.NET Membership(28) Azure(18) Barcode(2) Barcodes(3) BLOB(18) Business Rules(1) Business Rules/Logic(140) BYOD(13) Caching(2) Calendar(5) Charts(29) Cloud(14) Cloud On Time(2) Cloud On Time for Windows 7(2) Code Generator(54) Collaboration(11) command line(1) Conflict Detection(1) Content Management System(12) COT Tools for Excel(26) CRUD(1) Custom Actions(1) Data Aquarium Framework(122) Data Sheet(9) Data Sources(22) Database Lookups(50) Deployment(22) Designer(177) Device(1) DotNetNuke(12) EASE(20) Email(6) Features(101) Firebird(1) Form Builder(14) Globalization and Localization(6) How To(1) Hypermedia(2) Inline Editing(1) Installation(5) JavaScript(20) Kiosk(1) Low Code(3) Mac(1) Many-To-Many(4) Maps(6) Master/Detail(36) Microservices(4) Mobile(63) Mode Builder(3) Model Builder(3) MySQL(10) Native Apps(5) News(18) OAuth(8) OAuth Scopes(1) OAuth2(11) Offline(20) Offline Apps(4) Offline Sync(5) Oracle(10) PKCE(2) PostgreSQL(2) PWA(2) QR codes(2) Rapid Application Development(5) Reading Pane(2) Release Notes(180) Reports(48) REST(29) RESTful(29) RESTful Workshop(15) RFID tags(1) SaaS(7) Security(80) SharePoint(12) SPA(6) SQL Anywhere(3) SQL Server(26) SSO(1) Stored Procedure(4) Teamwork(15) Tips and Tricks(87) Tools for Excel(2) Touch UI(93) Transactions(5) Tutorials(183) Universal Windows Platform(3) User Interface(338) Video Tutorial(37) Web 2.0(100) Web App Generator(101) Web Application Generator(607) Web Form Builder(40) Web.Config(9) Workflow(28)
Archive
Blog
Saturday, March 7, 2015PrintSubscribe
Column Chart Type

The “column” chart type renders multiple vertical columns for each row of data. This chart type has many use cases, such as comparing values grouped by lookup values, or showing change over time. The example below shows the number of orders received over time in the Northwind sample app.

To use “column” chart type, add the keyword “column” to any “pivot-” tag, and make sure that it is separated with hyphens (-).

Data Field Tag
EmployeeID pivot1-row1-column

A column chart showing the count of orders made by each employee.

The data for the graph is displayed below.

The data for the chart showing the count of orders made by each employee.

Hovering over or clicking on a column will reveal the data.

A tooltip is shown for each column.

If multiple values are specified for each row of data, a column will be rendered for each value in a different color.

Data Field Tag
EmployeeID pivot1-row1-column
ShipVia pivot1-col1

Multiple values will render in multiple columns in the chart.

Multiple values for each row can be seen in the data below.

The data for the chart of count of orders by employee, split by shipper.

Each row can also be displayed as a single column and stack the values on that column by using the “columnstacked” chart type.

Data Field Tag
EmployeeID pivot1-row1-columnstacked
ShipVia pivot1-col1

Stacked columns will group all values for each datarow into a single column.