>I have a couple of questions:
>
>1.) When showing negative numbers on the graph, how do you prevent the axis labels from showing up at the top.
>
>2.) On a line chart, How do you change the colors and sizes of the lines. I guess what I'm asking is what are the properties names of the line and how do you change them?
>
>Thanks
First be warned that xlSeriesAxis is not compatible with 2d charts. To change color of a line you use SeriesCollection(nIndex).Border
#define xlThick 4
#define xlDashDotDot 5
with .SeriesCollection(1).Border
.Color = rgb(255,255,0)
.LineStyle = xlDashDotDot
.Weight = xlThick
endwith
SeriesCollection object has a lot of properties like Marker style, background, foreground, weight etc.
I couldn't understand the question with "negative".
Cetin