Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
For "Marker Line Style" see Point.Format.Line.Weight
This is not a question, just a place to record the answer to this question in
case somebody else searches for it; or I forget again in the future. I wanted to know: What object do I use to set the heaviness of the lines in a chart point marker? Not the series line, the point marker eg the asterisk xlMarkerStyleStar In the UI it's right-click, Format Data Point Marker Line style, Width 2pt say. In VBA I can set oPoint.MarkerStyle = xlMarkerStyleStar but I can't find any reference to "Marker Line Style" and neither did this newsgroup - until now I guess. And of course the macro recorder in Excel 2007 is broken and does not record many chart object changes. The magic word to think of searching for is "Weight" the answer is for a weight of 2, set Point.Format.Line.Weight=2 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
For "Marker Line Style" see Point.Format.Line.Weight
Thanks for writing about this. I spent several hours trying to figure out
how to reduce Line Width and it never once occured to me to look at Format. In my case I needed to change the Series line width. Series.Format.Line.Weight = 1 worked perfectly. (Excel 2007 offers 6 different chart styles with 8 different color combinations and I hate every one.) |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
For "Marker Line Style" see Point.Format.Line.Weight
One more wrinkle: Setting the marker weight draws a line from the previous point to this one (why? whatever for? is this documented anywhere?) oPoint.Format.Line.Weight = xlThin ' =2; xlthick=4 To then remove the unwanted lines that are added, do ' Finally remove the pesky lines that Excel adds to the star points oChart.SeriesCollection(1).Border.LineStyle = xlLineStyleNone ' Excel 2007 macro recorder does not record this "mischab1" wrote: In my case I needed to change the Series line width. Series.Format.Line.Weight = 1 worked perfectly. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Find" a wildcard as a place marker and "replace" with original va | Excel Discussion (Misc queries) | |||
xy plot line style change when I select "fixed maximum" | Charts and Charting in Excel | |||
How do you select line or columns in "Line-Column on 2 axes" graphs? | Excel Discussion (Misc queries) | |||
select & format "single" axis line in charts | Charts and Charting in Excel | |||
How can I turn on "Line Style"? | Excel Worksheet Functions |