+ Reply to Thread
Results 1 to 3 of 3

How do you manipulate chart objects?

  1. #1
    Registered User
    Join Date
    12-03-2011
    Location
    Walnut Cove, NC
    MS-Off Ver
    Office 365
    Posts
    98

    How do you manipulate chart objects?

    Hello,

    I have been working on a chart (scatter plot) for work, I have gotten most of the bugs worked out, however there are a few issues. I needed to insert several drawing objects into my chart for a quick visual of a tested substrate as good/moderate/bad - I used a green/yellow/red theme. the objects are inserted, the look good, the problem is the line in the chart is behind the objects so that when it passes through the different colors it "changes" color, I have it set to black, but I can't bring it forward so that it is black all of the time.

    Any help would be most appreciated!

    Thanks,

    Matt

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,920

    Re: How do you manipulate chart objects?

    I think if you record a macro to do this, it will give you the correct syntax. The macro recorder doesn't produce great code, but it often tells you how to reference objects.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

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

    Re: How do you manipulate chart objects?

    You can not change the zorder of objects within a chart object.

    If your shapes are giving the plot area different colours perhaps you need to use series to draw the colour bands rather than shapes.
    Cheers
    Andy
    www.andypope.info

+ 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. Chart Objects
    By NatalieEC in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-24-2014, 02:58 PM
  2. Manipulate Chart.DataTable
    By rlssousa in forum Excel General
    Replies: 5
    Last Post: 11-21-2012, 10:43 AM
  3. Manipulate data table below the pivot chart
    By Malette in forum Excel General
    Replies: 7
    Last Post: 03-28-2012, 11:45 AM
  4. VBA to manipulate a dynamic chart
    By amyowm in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-27-2010, 12:01 PM
  5. Manipulate Chart with High and Low Values
    By 2709236 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 06-17-2009, 11:34 AM
  6. Align/Manipulate multiple chart on one page
    By BT in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-22-2005, 05:00 PM
  7. [SOLVED] Chart Objects
    By Bill in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-18-2005, 09:05 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