Ask Your Question

Changing the colour of a datapoint based on the value [closed]

asked 2013-01-09 16:53:25 +0100

Ross Thompson gravatar image

updated 2013-02-03 09:40:26 +0100

qubit gravatar image

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?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-19 22:38:27.247068

1 Answer

Sort by » oldest newest most voted

answered 2013-01-10 05:41:37 +0100

ROSt52 gravatar image

I feel that it is possible but you would need a macro to do what you do currently manually.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2013-01-09 16:53:25 +0100

Seen: 446 times

Last updated: Jan 10 '13