ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   is there a conditional xls chart (ie change the graph dot color)? (https://www.excelbanter.com/charts-charting-excel/97126-there-conditional-xls-chart-ie-change-graph-dot-color.html)

bribri

is there a conditional xls chart (ie change the graph dot color)?
 
how do i setup a conditional xls chart? for example the individual points at
the chart color changes w/ the condtion (ie if it is below 90, turn red, if
it is above 90 trun green, etc)?

kindly,

b. lee

Andy Pope

is there a conditional xls chart (ie change the graph dot color)?
 
Have a look here for details.
http://peltiertech.com/Excel/Charts/...nalChart1.html

Cheers
Andy

bribri wrote:
how do i setup a conditional xls chart? for example the individual points at
the chart color changes w/ the condtion (ie if it is below 90, turn red, if
it is above 90 trun green, etc)?

kindly,

b. lee


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info


All times are GMT +1. The time now is 12:31 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com