+ Reply to Thread
Results 1 to 3 of 3

Chart created with VBA needs corrections to format, data labels

  1. #1
    Registered User
    Join Date
    11-25-2024
    Location
    Italy
    MS-Off Ver
    Office 365
    Posts
    15

    Chart created with VBA needs corrections to format, data labels

    Hi all,
    i'm trying to create a scatter chart in VBA with 3 sets of data, but I have some issues that I can't solve:
    - the legend should be aligned with the top of the chart
    - the forecolor of the markers is always blue instead of red/green
    - remove the countour lines from markers
    - Each point should have a label taken from the columns J and O, instead appear labels from columns I and N
    - the axis labels should be bold

    I've attached the file with code. You'll see two charts, the first is the output of the code, the second is the correct one.

    thanks in advance for any advice
    Attached Files Attached Files
    Last edited by 6StringJazzer; 07-04-2025 at 11:21 AM. Reason: better titles please

  2. #2
    Forum Contributor
    Join Date
    01-25-2025
    Location
    Presov, Slovakia
    MS-Off Ver
    2021
    Posts
    297

    Re: Chart created with VBA needs corrections to format, data labels

    Hi,
    try the attached file first.

    1.- the legend should be aligned with the top of the chart
    Please Login or Register  to view this content.
    2.- the forecolor of the markers is always blue instead of red/green
    Please Login or Register  to view this content.
    3. - remove the countour lines from markers
    Please Login or Register  to view this content.
    4.- Each point should have a label taken from the columns J and O, instead appear labels from columns I and N
    Please Login or Register  to view this content.
    5. - the axis labels should be bold
    Please Login or Register  to view this content.
    m.s.
    Attached Files Attached Files
    Last edited by MSDols; 07-04-2025 at 06:48 PM. Reason: text correction

  3. #3
    Registered User
    Join Date
    11-25-2024
    Location
    Italy
    MS-Off Ver
    Office 365
    Posts
    15

    Re: Chart created with VBA needs corrections to format, data labels

    Perfect, it works.
    Thanks

+ 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. VBA Chart Font Issue:Same code some Chart Working Some Chart Not Working ...
    By DavidTan2019 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-13-2019, 08:38 PM
  2. Replies: 0
    Last Post: 01-07-2015, 01:22 PM
  3. Chart order in trad. Pivot Chart vs. PowerPivot chart
    By mr_jules in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-06-2015, 11:17 AM
  4. Replies: 5
    Last Post: 08-08-2011, 02:09 PM
  5. can we combine line chart and colum chart in one chart
    By reedzhou in forum Excel General
    Replies: 1
    Last Post: 06-20-2011, 10:03 PM
  6. [SOLVED] Cannot Activate Chart Area in Chart. Chart Object Failed
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-07-2006, 09:45 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