| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatic chart colours
On Oct 6, 3:12*am, "Michael.Tarnowski" wrote:
use a helper column in your chart data source to define Excel's ColorIndex and then use one of Jon Peltier's VBA macros: * VBA Conditional Formatting of Charts by Value:http://peltiertech.com/WordPress/vba...ting-of-charts... * VBA Conditional Formatting of Charts by Series Name:http://peltiertech.com/WordPress/vba...ting-of-charts... Excel displays only 56 different colors. For more information on Color Palette and the 56 Excel ColorIndex Colors seehttp://www.mvps.org/dmcritchie/excel/colors.htm. Hope that helps Many thanks - I'll check it out -- Nige Danton |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Chart/Graph colours | New Users to Excel | |||
| Chart bar colours | Excel Discussion (Misc queries) | |||
| Chart Colours | Excel Discussion (Misc queries) | |||
| Chart Colours | Charts and Charting in Excel | |||
| two colours in the plot are of a chart | Charts and Charting in Excel | |||
Threaded Mode
