| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Determine real colour of automatic line colours?
I am creating a chart and adding trendlines via VBA - which is all working
marvellously. Each series is assigned a colour automatically. What I'd like to achieve is to set the related trendline to be a darker version of the line colour. However I can't see a way of finding the colour assigned to the series (which are set as xlAutomatic by Excel) Is this possible? Or will I have to manage the colours of the series and trends myself? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatic chart colours | Excel Worksheet Functions | |||
| can't see font colours and fill colour on screen | Setting up and Configuration of Excel | |||
| determine cell colour | Excel Discussion (Misc queries) | |||
| Format colour of cells based on other cell - 34 colours | Excel Programming | |||
| How do you select the colours on Microsoft excel colour pallets? | Excel Discussion (Misc queries) | |||
Threaded Mode
