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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Determine real colour of automatic line colours?
I recorded a macro while manually changing the trend line color. this is
what I got. Sub Macro1() ' ' Macro1 Macro ' Macro recorded 10/18/2007 by Joel ' ' ActiveSheet.ChartObjects("Chart 1").Activate ActiveChart.SeriesCollection(1).Trendlines(1).Sele ct ActiveChart.SeriesCollection(1).Trendlines(1).Sele ct With Selection.Border .ColorIndex = 4 .Weight = xlMedium .LineStyle = xlContinuous End With End Sub "DuncanL" wrote: 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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Determine real colour of automatic line colours?
I recorded a macro while manually changing the trend line color. this is
what I got. Thanks for the help, but I know how to change the colours; the question is how to find out the actual colour assigned to a series that has its ColorIndex property set as xlAutomatic. I could then use that information to calculate a darker colour and assign that to the associated trendline colour. I've gone for manually assigning known colours to the series and trendlines, from an array that I have set up initially, so it's now more of a question out of curiosity, but it would be nice to know. |
Reply |
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) |