How to Color Line Charts in Spotfire with a Property Control

Do you get frustrated when you set the colors in a Spotfire chart, only to see them change after updating the expression, aggregation method, or display name? In this video, I’ll show you how to assign a color to a document property to make the document property update not only the values on a chart, but also the color.


[ninja-popup ID=1679] Click here to download the Spotfire file shown in the screenshot! [/ninja-popup]

Different companies and industries follow standardized color schemes to make charts easier to interpret. For example, the oil industry commonly displays Oil, Natural Gas, and Water data points with the colors greed, red, and blue, respectively.

It’s often useful to have a Property Control (such as a Drop Down List or List Box) to change the column on a chart axis. However, it can be tricky to get Spotfire to use the color you want when the column selection changes in the Property Control, without spending a lot of time setting up the colors. The good news is that you can color a chart with the same Document Property used in the Property Control.

Watch the video below to learn how to do this, and [ninja-popup ID=1679] download the Spotfire file to follow along. [/ninja-popup]

If the embedded player above isn’t working, this video is also on YouTube:

Questions / Comments
If you have any questions or comments, or if there’s something you’d like featured on this blog, feel free to email me at or leave a comment below.

Leave a Reply

Your email address will not be published. Required fields are marked *