Formatting Excel Graphs from Lotus Script

hcl-bot · November 14, 2013, 10:41am

Hi, I am coding a script to export a lot of data from a Notes database to an Excel sheet including graphs. At the end I would like to format the colors used in the graph. I am currently using the following line for this:

xlApp.ActiveWorkbook.ActiveChart.Legend.LegendEntries(1).LegendKey.Fill.ForeColor.SchemeColor = 3

which is working quite well but would anyone know what to use to get access to the full RGB color palette?

(Like the difference between xlsheet.Cells(1,1).font.color and xlsheet.Cells(1,1).font.colorindex for the cell font color).

hcl-bot · November 18, 2013, 6:05pm

Subject: Might be best to try an MS Excel VBA forum

The issue is specific to MS Excel and you might be able to get an answer from people who work extensively with it.

hcl-bot · November 19, 2013, 9:03am

Subject: Quick search of google for Excel VBA forecolor provides…

xlApp.ActiveWorkbook.ActiveChart.Legend.LegendEntries(1).LegendKey.Fill.ForeColor = RGB(127,187,199)