Formatting Lines in combination charts

BarrettM · Mar 27th, 2002, 06:45 AM

I create a couple of graphs using macros, they are combination graphs (area and Line).
In the macro, I wish to be able to format the line to a thicker line or perhaps broken line.
I tried to record this process but it doesn't seem to work.
Any suggestions please, and again thank you.

Sbirro Cornuto · Mar 27th, 2002, 06:57 AM

The code for making SeriesCollection(1)-line thick and dotted would look like this:

With ActiveChart.SeriesCollection(1).Border
.ColorIndex = 57
.Weight = xlThick
.LineStyle = xlDot
End With

So use it with any SeriesCollection by changing the index. Does this help you?

BarrettM · Mar 27th, 2002, 07:01 AM

Thank you Sbirro

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 27th, 2002, 06:45 AM	#1
BarrettM Board Regular Join Date: Mar 2002 Location: Northern Ireland Posts: 113	I create a couple of graphs using macros, they are combination graphs (area and Line). In the macro, I wish to be able to format the line to a thicker line or perhaps broken line. I tried to record this process but it doesn't seem to work. Any suggestions please, and again thank you.

Mar 27th, 2002, 06:57 AM	#2
Sbirro Cornuto Board Regular Join Date: Mar 2002 Location: Little Italy Posts: 93	The code for making SeriesCollection(1)-line thick and dotted would look like this: With ActiveChart.SeriesCollection(1).Border .ColorIndex = 57 .Weight = xlThick .LineStyle = xlDot End With So use it with any SeriesCollection by changing the index. Does this help you?

Mar 27th, 2002, 07:01 AM	#3
BarrettM Board Regular Join Date: Mar 2002 Location: Northern Ireland Posts: 113	Thank you Sbirro