Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I use VBA to change line colors
I have a multi-series 2-D line chart. Each series is a different color, but these colors appear to be chosen automatically, and are not the colors I want to use. I've tried this: GraphObj.SeriesCollection(2).Interior.Color = RGB(255, 180, 0) But this generates the error "Unable to set the Color property of the Interior class." So, where in the depths of the object model can I go to change the color of the lines? And if you can tell me that, I'll bet you can also tell me where to go to change the width or thickness of a line, too. Any help is very much appreciated. -- Dilbert00 ------------------------------------------------------------------------ Dilbert00's Profile: http://www.excelforum.com/member.php...o&userid=23993 View this thread: http://www.excelforum.com/showthread...hreadid=376141 |
#2
|
|||
|
|||
Hi,
For a line you would need, GraphObj.SeriesCollection(2).Border.Color = RGB(255, 180, 0) and for other formatting try these instead of Color. .Weight = xlMedium .LineStyle = xlContinuous Using the macro recorder is a good way of getting this syntax. You can change the automatic colours for charts. Use the menu Tools Options. On the Color tab is a section for chart lines and fills. Cheers Andy Dilbert00 wrote: I have a multi-series 2-D line chart. Each series is a different color, but these colors appear to be chosen automatically, and are not the colors I want to use. I've tried this: GraphObj.SeriesCollection(2).Interior.Color = RGB(255, 180, 0) But this generates the error "Unable to set the Color property of the Interior class." So, where in the depths of the object model can I go to change the color of the lines? And if you can tell me that, I'll bet you can also tell me where to go to change the width or thickness of a line, too. Any help is very much appreciated. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change multi-line entries to single line entries in Exce. | Excel Worksheet Functions | |||
How do I change background colors between secondary y axis lines? | Charts and Charting in Excel | |||
In mixed bar and line chart. I cannot change one of my source da. | Charts and Charting in Excel | |||
In mixed bar and line chart. I cannot change one of my source da. | Charts and Charting in Excel | |||
How do I change the colour of/remove the Freeze Panes line in Exce | Excel Worksheet Functions |