Conditional Chart Formatting?
 

Is it possible to have a series data point (2) change colour if the value
drops below that of data point (1) and revert back again if it rises above
that of data point (1). (And possibly be a third colour if it is equal in
value)?
Sandy

Conditional Chart Formatting?
 

Hi,

Yes it's possible. Creating a chart with multiple series is the way to go.
Have a look at Jon's page for more information.
http://peltiertech.com/Excel/Charts/...nalChart1.html

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Sandy" wrote in message
...
Is it possible to have a series data point (2) change colour if the value
drops below that of data point (1) and revert back again if it rises above
that of data point (1). (And possibly be a third colour if it is equal in
value)?
Sandy

Conditional Chart Formatting?
 

Very interesting, thank you.
Sandy

"Andy Pope" wrote in message
...
Hi,

Yes it's possible. Creating a chart with multiple series is the way to go.
Have a look at Jon's page for more information.
http://peltiertech.com/Excel/Charts/...nalChart1.html

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Sandy" wrote in message
...
Is it possible to have a series data point (2) change colour if the value
drops below that of data point (1) and revert back again if it rises
above
that of data point (1). (And possibly be a third colour if it is equal in
value)?
Sandy