+ Reply to Thread
Results 1 to 3 of 3

Need Help With Setting Series Collection Width Using VBA

  1. #1
    Forum Contributor
    Join Date
    10-25-2010
    Location
    Phoenix, Arizona, USA
    MS-Off Ver
    O365
    Posts
    201

    Need Help With Setting Series Collection Width Using VBA

    Lots of graphs, so many to change, want to do it using VBA.

    Need to set the width of a SeriesCollection to a particular width.

    I've tried:
    Please Login or Register  to view this content.
    Can't find any properties for the SeriesCollection in help...

    You're the best!

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,650

    Re: Need Help With Setting Series Collection Width Using VBA

    I think that there is nothing like width of seriescollection.
    May be you have column graph - you can change the gap between columns (but then not on seriescollection but on chartgroups):
    Please Login or Register  to view this content.
    (the gap is in %)

  3. #3
    Forum Contributor
    Join Date
    10-25-2010
    Location
    Phoenix, Arizona, USA
    MS-Off Ver
    O365
    Posts
    201

    Re: Need Help With Setting Series Collection Width Using VBA

    The charts are scatter graphs with lines connecting the data points.

+ 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. Replies: 2
    Last Post: 12-23-2011, 11:04 AM
  2. Runtime Error 1004 when Setting Setting Series Values
    By tonymctigue in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 04-09-2010, 10:05 AM
  3. Naming a series collection
    By Jaspercat in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-24-2008, 04:55 AM
  4. Series collection object
    By Doc Holiday in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 10-10-2007, 04:49 PM
  5. How to store the lengthy value in Series collection?
    By ramkumar_cpt in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-16-2005, 09:20 AM

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