| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
conditional formating of a chart?
Can you place conditional formats on charts? I know you can with cells but I
want a chart to reflect distinction between values or < a chosen number. |
|
#2
|
|||
|
|||
|
Hi,
The is no built-in CF for charting. Have a look at John Peltier's work around. http://peltiertech.com/Excel/Charts/...nalChart1.html Cheers Andy JohnA wrote: Can you place conditional formats on charts? I know you can with cells but I want a chart to reflect distinction between values or < a chosen number. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
conditional formating of a chart?
"JohnA" wrote: Can you place conditional formats on charts? I know you can with cells but I want a chart to reflect distinction between values or < a chosen number. You can kind of do it with a surface chart... |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
conditional formating of a chart?
Here's how to apply conditional formats of a sort to regular charts:
http://peltiertech.com/Excel/Charts/...nalChart1.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "mikeweasel" wrote in message ... "JohnA" wrote: Can you place conditional formats on charts? I know you can with cells but I want a chart to reflect distinction between values or < a chosen number. You can kind of do it with a surface chart... |
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
conditional formating of a chart?
Has Excel 2007 made any improvements for conditional formatting of charts or
is your solution below still the best alternative? "Jon Peltier" wrote: Here's how to apply conditional formats of a sort to regular charts: http://peltiertech.com/Excel/Charts/...nalChart1.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "mikeweasel" wrote in message ... "JohnA" wrote: Can you place conditional formats on charts? I know you can with cells but I want a chart to reflect distinction between values or < a chosen number. You can kind of do it with a surface chart... |
|
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
conditional formating of a chart?
Excel 2007 did not introduce any features that would make this easier.
It's really not so hard, either, it just takes a bit more effort. - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ DonnaC wrote: Has Excel 2007 made any improvements for conditional formatting of charts or is your solution below still the best alternative? "Jon Peltier" wrote: Here's how to apply conditional formats of a sort to regular charts: http://peltiertech.com/Excel/Charts/...nalChart1.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "mikeweasel" wrote in message ... "JohnA" wrote: Can you place conditional formats on charts? I know you can with cells but I want a chart to reflect distinction between values or < a chosen number. You can kind of do it with a surface chart... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help using Conditional Formating of Entire Rows | Excel Worksheet Functions | |||
| Conditional formating in Charts | Charts and Charting in Excel | |||
| more than 3 conditional formating in excel | Excel Discussion (Misc queries) | |||
| Conditional formating in Excel Charts. | Charts and Charting in Excel | |||
| 30 Day Aging Report Using Conditional Formating | Excel Worksheet Functions | |||
Linear Mode
