Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

chart colors

I have a stock chart (not actually stock data, but I have a floating bar with "high" and "low" data, so it seemed to fit), and the data it's based on has conditional formatting applied to make the cell background change colour when certain criteria are met. Both the high and low value are used to calculate the colour, and they both get the same colour.

I would like the bars in the chart to reflect that colour. I can go in and manually change the colour for each datapoint to be the right colour, but I'd rather have a way of making it happen automatically.

Is this possible?

chart colorsChanging the colour of a datapoint based on the value

I have a stock chart (not actually stock data, but I have a floating bar with "high" and "low" data, so it seemed to fit), and the data it's based on has conditional formatting applied to make the cell background change colour when certain criteria are met. Both the high and low value are used to calculate the colour, and they both get the same colour.

I would like the bars in the chart to reflect that colour. I can go in and manually change the colour for each datapoint to be the right colour, but I'd rather have a way of making it happen automatically.

Is this possible?

click to hide/show revision 3
retagged

Changing the colour of a datapoint based on the value

I have a stock chart (not actually stock data, but I have a floating bar with "high" and "low" data, so it seemed to fit), and the data it's based on has conditional formatting applied to make the cell background change colour when certain criteria are met. Both the high and low value are used to calculate the colour, and they both get the same colour.

I would like the bars in the chart to reflect that colour. I can go in and manually change the colour for each datapoint to be the right colour, but I'd rather have a way of making it happen automatically.

Is this possible?