ASP.NET

Suppose that you have a chart on the Orders page that shows the number of orders made by up to 10 customers. By default, the rows are sorted in ascending alphabetical order of the customer’s name.

The chart with alphabetically sorted customers is shown below.

The chart data shows that the first ten customers were included in the chart.

The customers can also be sorted in descending alphabetical order by using the keyword “sort” or “sortdesc”.

The new chart shows the first 10 customers in descending order.

The chart data will show customers sorted in descending alphabetical order.

Sometimes it may be necessary to sort the rows by a column value. Use “sortbyvalue” or “sortdescbyvalue” to sort in descending order of the row value.

The chart now shows the top 10 customers that make orders.

The data shows that the rows have been sorted by the “Count of Orders” column.

In a similar fashion, the bottom 10 customers making orders can be displayed by using “sortascbyvalue” keyword.

The chart now shows the least active customers.

The chart data will reveal the correct ascending order.

Column fields can be sorted with the same keywords. For example, the chart below shows the top 5 employees making orders over the Order Date. It appears “Peacock” made the most orders in this time period.

The data can be seen here:

Line and area charts allow the user to click on a data point to see the value. The chart below shows how the tooltip appears.

However, it can be difficult to gauge where the actual value is on the horizontal and vertical axes. Using the “crosshair” keyword in the tag will enable a horizontal and vertical line that makes it easier for the user to see the value in relation to the chart. The color of the crosshair also shows which value is selected.

The “crosshair” keyword will by default enable a line for both the horizontal and vertical axis. The “crosshair” property can also use the value “horizontal” or “vertical” to limit the line to the respective axis.