Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Chart Conditional Formatting | Excel Discussion (Misc queries) | |||
chart conditional formatting | Excel Discussion (Misc queries) | |||
Can I Apply Conditional Formatting to a Chart? | Charts and Charting in Excel | |||
Conditional formatting a bar chart | Charts and Charting in Excel | |||
Conditional formatting in a chart | Charts and Charting in Excel |