+ Reply to Thread
Results 1 to 1 of 1

Dynamically Change Marker Size and Background Colour for XY Scatter

  1. #1
    Registered User
    Join Date
    02-05-2016
    Location
    New Zealand
    MS-Off Ver
    2013
    Posts
    1

    Dynamically Change Marker Size and Background Colour for XY Scatter

    Hi all, I have a problem that I've literally lost sleep over

    I have a XY Scatter with Straight Lines and Markers chart. This chart shows a stakeholder relationship between the different team members. (example attached to this post)

    For each member, we want to define a marker colour and size. The members, sizes and colours will be specific to each client the report is presented to. In addition the number of members will range from 5 to 15.

    I know how to do this with a standard line chart. However, the same concept doesn't seem to work with the XY Scatter.

    Can any one help?

    Thanking you in advance.
    M.
    Attached Files Attached Files

+ 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] Change series line colour to match marker colours
    By sweep in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-15-2014, 03:04 AM
  2. Replies: 0
    Last Post: 06-29-2013, 04:25 AM
  3. VBA to change label, marker style and colour
    By Rajoli in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-27-2012, 08:31 AM
  4. Replies: 1
    Last Post: 03-26-2012, 02:52 PM
  5. Scatter Graphs + dynamically increase marker size?
    By fergalc in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-15-2007, 10:19 PM
  6. [SOLVED] change a cell background colour to my own RGB colour requirements
    By Stephen Doughty in forum Excel General
    Replies: 4
    Last Post: 06-16-2006, 08:15 AM
  7. Change the size of a chart marker in the legend
    By Thea in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-13-2006, 04:45 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