+ Reply to Thread
Results 1 to 3 of 3

right side border of chart missing

  1. #1
    Registered User
    Join Date
    09-03-2014
    Location
    U.S.
    MS-Off Ver
    2010
    Posts
    4

    right side border of chart missing

    I have an excel chart that I am converting from VBA to VB.NET. I am new to excel charts so bear with me please. The right border line of the chart used to be there when it printed in VBA but is missing when I run it in VB.NET. I attached the chart to this post. Here is my code.

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by sandrai; 09-04-2014 at 06:35 AM.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,434

    Re: right side border of chart missing

    Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

    Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

    Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



    (This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)


    Try adding border to the PlotArea.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    09-03-2014
    Location
    U.S.
    MS-Off Ver
    2010
    Posts
    4

    Re: right side border of chart missing

    I added one line to add a black border - .border.colorindex = 1
    It worked, thank you so much.

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Excel chart missing bottom border in Word
    By Beeblebrox in forum Word Formatting & General
    Replies: 15
    Last Post: 09-07-2011, 12:10 PM
  2. Missing bottom border of Excel chart in Word 2007
    By karynNL in forum Excel General
    Replies: 1
    Last Post: 09-22-2010, 02:08 AM
  3. [SOLVED] in excel the option to "compare side by side with" is missing.
    By lost lucy in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 10-06-2005, 09:05 PM
  4. [SOLVED] How do I make a stacked column chart with side-by-side comparison.
    By Tim in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-08-2005, 11:05 PM
  5. [SOLVED] Data markers in a stacked chart will not sit side by side by month
    By WCH CHART PERSON in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-28-2005, 12:06 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1