+ Reply to Thread
Results 1 to 2 of 2

Automatic centering of ThinkCell chart legends in PPT via Excel VBA

  1. #1
    Registered User
    Join Date
    11-01-2020
    Location
    Munich, Germany
    MS-Off Ver
    MS Office 365
    Posts
    1

    Automatic centering of ThinkCell chart legends in PPT via Excel VBA

    Hello everyone,

    I have the following problem: I fill a ThinkCell chart in PowerPoint automatically using VBA in Excel. Depending on the countries which are in the legend, the positioning of the legend varies (due to the different lengths of the country names) so that it is no longer exactly centered above the chart, as it was before the automated filling. Unfortunately I have not yet found a way to automatically place the legends above the charts using a VBA sub in Excel. I would actually like to avoid opening the 500 automatically created PPT presentations again and manually centering the legend above the chart in each one.

    Maybe one of you can help me. Unfortunately, my VBA knowledge is still quite limited, but I usually manage to understand scripts and adapt them to my case.

    Thanks in advance and best regards
    H.-W.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider (Windows 10)
    Posts
    51,216

    Re: Automatic centering of ThinkCell chart legends in PPT via Excel VBA

    Welcome to the forum.

    There are instructions at the top of the page explaining how to attach your sample workbook and PPTX.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

+ 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: 4
    Last Post: 09-21-2020, 10:02 AM
  2. Automatic refresh of all thinkcell charts in PowerPoint file
    By GeorgeIv in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-27-2020, 11:11 AM
  3. VBA Script to Copy a thinkcell graph from powerpoint to excel
    By TollemG in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-20-2017, 01:06 PM
  4. Link thinkcell with excel
    By aissam in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-06-2016, 08:49 AM
  5. graphing a chart in VBA, showing series legends on the chart
    By Lifeseeker in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-05-2012, 07:12 AM
  6. [SOLVED] Excel 2007 Beta 2: Chart Title Centering Suggestion
    By dzuy in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-06-2006, 05:20 PM
  7. Excel Chart Legends need alignment option (rotate 90-180-270 deg)
    By ron ebelhar in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 08-29-2005, 02:05 PM

Tags for this Thread

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