Color Individual Rows/Columns

This will require Builder privileges for setup and implementation.

iDashboards can set individual colors to columns but not to rows. However, as of 11/19/2020: v10.6 Improvements to the Bar/Column Charts were made. A new property: Bar/Column Color Type, adds the ability to utilize a specific color per-bar/column! Previously, bars could only be colored per Y-Axis Color or Range Color. The information used below can be found in the Chart Examples dashboards pack.

Starting Charts – Resolution Charts

Chart Design – Color Selection

Starting Charts

Resolution Charts

Starting Charts – Color Selection

Chart Design

Create the chart with the following Data Structure:

1. Input user friendly labels: X-Axis Label, Name, Data Column, Data Type
2. Select the Chart Data Source
   • Table/View select the Table you will use
   • Stored Procedure select the Table you will use
   • Excel Sheets select the Named Range you will use
   •  
3. Click Next
4. Then map your Data Columns to the Labels given
   • Pivot and Hide will automatically appear if they are options for your Data Set
5. Choose Column Chart, then Clustered Column
6. Click Next then you will have created the Starting Charts

Starting Charts – Resolution Charts

Chart Design

Color Selection

Changing the Bar/Column Colors

1. In Chart Properties select Clustered Bar/Column Settings
2. Set Bar/Column Color Type to Y-Axis Colors
3. Select Colors and set your Y-Axis Colors
4.  You will then have created the Resolution Charts

Starting Charts – Resolution Charts

Chart Design – Color Selection

For More Information:

• Dashboard & Chart Design Articles
• iDashboards Builder Manual 4.3 Colors
• iDashboards Builder Manual 9.1 Bar Charts
• iDashboards Builder Manual 9.2 Column Charts
• iDashboards Builder Manual 7.3 Chart Designer
• iDashboards Builder Manual 8 Designing Charts

If the above is unable to resolve the issue, then please contact truOI Support for further assistance.