Changing the Chart Color Metric
You can change the metric used to determine the colors used on a chart. You can specify the default chart color metric and group fields for charts on the Charts tab of your data source configurations. A shortcut to this tab is available when working with a chart by selecting Defaults on the chart menu ().
Click the color metric on your chart. A Color dialog appears.
Select a new metric to be used to determine the colors on your chart.
Select the aggregation function that should be used with the color metric: SUM, AVG, MAX, MIN, or (for some data sources) LAST VALUE. See Available Metric Functions.
The chart renders using colors determined by the select metric and its aggregated values.