You can customize the chart appearance by changing these target properties of the chart plot.
Let us add custom labels in the following chart, where the default labels for the X-Axis show Ship Names since the Category Groups area is bound to [ShipName].
The chart binds to the 'Invoices' table of the Nwind.db. See Custom Data Provider for more information.
You can customize the X-Axis labels of the above chart as follows to show 'City' along with 'Ship Name'.
The below image shows how the X-Axis labels show customized labels.
Let us add custom labels for the chart data series in the chart created in the Create Multiple Line Chart tutorial by following the below steps.
To add a tooltip in a chart with ['Global_Sales'] as chart data, displayed along the Y-Axis, follow the below steps:
Select the series data and use expressions as follows in the corresponding properties to see the effect. Refer to the Create Clustered Column Chart tutorial, with only one series for simplicity.
Select the Chart Data series (here [Net Sales]) and from the Properties panel, set the expression of FillColor property to the following:
Copy Code
|
|
---|---|
IIF(Sum(Fields.Item("Net Sales").Value)>450000,"Red") |
Select the Chart Data series (here [Net Sales]) and from the Properties panel, set the expression of LineColor, LineStyle, and LineWidth properties respectively to the following:
LineColor |
Copy Code
|
---|---|
=IIF(Sum(Fields.Item("Net Sales").Value)>450000,"Red","Grey") |
LineStyle |
Copy Code
|
---|---|
=IIF(Sum(Fields.Item("Net Sales").Value)>450000,"Double","Dotted") |
LineWidth |
Copy Code
|
---|---|
=IIF(Sum(Fields.Item("Net Sales").Value)>450000,"4pt","1pt") |
For charts such as Line, Radar Line, which are composed of markers or data point symbols, have the properties that can be set for conditional formatting. For example, in Create Single Line Chart tutorial, we can highlight the markers as shown.
To do so, with the Chart Data series (here [Return Quantity]) selected, from the Properties panel, go to Marker > BackgroundColor. and set the expression to the following.
Example Title |
Copy Code
|
---|---|
=IIF(Sum(Fields!ReturnQuantity.Value)>5,"Red","Grey") |
Similarly, expressions for Marker border settings > LineColor, LineStyle, and Width can be set.