+ Reply to Thread
Results 1 to 2 of 2

Add rectangle shapes at the beginning and end of a bar

  1. #1
    Registered User
    Join Date
    04-13-2015
    Location
    texas
    MS-Off Ver
    2013
    Posts
    1

    Add rectangle shapes at the beginning and end of a bar

    Hi,

    I am creating a gantt view of data that i pull in from project to excel. I am able to create the gantt bars but would like to change the look of the summary task bar by adding small rectangles at the beginning and end just like in project where we have upside-down triangles.
    Can some please assist me.

    Thanks,
    Savitha

  2. #2
    Forum Contributor
    Join Date
    09-30-2013
    Location
    Toronto, ON
    MS-Off Ver
    Excel 2007
    Posts
    229

    Re: Add rectangle shapes at the beginning and end of a bar

    Depending on how you're creating your bar, you can try adding CHR(n) before and after the bar. Where n is the character you want at each end.
    If this helped, please click (*) Add Reputation

+ 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. [SOLVED] TextBox turns into a rectangle when using AvtiveSheet.Shapes
    By sur4j in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-06-2014, 04:35 PM
  2. [SOLVED] followup top shapes as one colour, exclude 2 shapes
    By deancorleone in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-01-2013, 02:14 PM
  3. [SOLVED] Detecting shapeS out of rectangle perimeters
    By Heva in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-30-2013, 05:34 AM
  4. How To Move Shapes From Another Shapes? (floating shapes)
    By MarcLev in forum Word Programming / VBA / Macros
    Replies: 2
    Last Post: 10-04-2009, 04:04 PM
  5. [SOLVED] Formatting Auto Shapes - Rectangle
    By Woody13 in forum Excel General
    Replies: 1
    Last Post: 05-19-2005, 04: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