Results 1 to 8 of 8

Thread: [RESOLVED] Excel VBA - how to remove chart series marker line color

Threaded View

  1. Aug 30th, 2013, 02:57 PM #8
    VBAhack
    VBAhack is offline

    Thread Starter
    Fanatic Member VBAhack's Avatar
    Join Date
    Dec 2004
    Location
    Sector 000
    Posts
    617

    Re: [RESOLVED] Excel VBA - how to remove chart series marker line color

    Actually, I found a way to do it for the entire series instead of point by point. The trick was to use the value -2 (xlHundreds or xlParamTypeBinary) instead of -4142 (xlNone) for the MarkerForegroundColor. I discovered it by turning off the marker line using the excel dialog boxes, then running a macro to tell me the marker foreground color. Also, I'd been fiddling with the wrong item - background color instead of foreground color. Thanks for your inspiration!

    What really goofed me up was the macro recorder. It wasn't even close.
    Last edited by VBAhack; Aug 30th, 2013 at 04:04 PM.
    VBAhack
    (Links: Cubic Spline Tutorial, Parametric Cubic Spline Tutorial, VB Numerical Routines    )

    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width