Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 21
Default 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   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 21
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
"Find" a wildcard as a place marker and "replace" with original va Eric Excel Discussion (Misc queries) 1 January 27th 09 07:00 PM
xy plot line style change when I select "fixed maximum" flobear Charts and Charting in Excel 1 November 17th 07 02:54 PM
How do you select line or columns in "Line-Column on 2 axes" graphs? mizterbusy Excel Discussion (Misc queries) 0 September 19th 06 06:48 AM
select & format "single" axis line in charts Guru Guy Charts and Charting in Excel 1 February 21st 06 04:36 AM
How can I turn on "Line Style"? LarryH Excel Worksheet Functions 1 January 22nd 06 03:41 PM


All times are GMT +1. The time now is 08:03 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"