+ Reply to Thread
Results 1 to 5 of 5

Give points for each data series in scatter chart a color, shape, and label,+ auto update

Hybrid View

  1. #1
    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,863

    Re: Give points for each data series in scatter chart a color, shape, and label,+ auto upd

    It is not clear, if you have separate series for each color (with Y values based on your B column, and X values based on C,D,etc)? Probably instead of posting screenshots it would be better to attach sample file (see http://www.excelforum.com/forum-rule...rum-rules.html )
    Best Regards,

    Kaper

  2. #2
    Registered User
    Join Date
    01-22-2016
    Location
    Tokyo, Japan
    MS-Off Ver
    2013
    Posts
    5

    Re: Give points for each data series in scatter chart a color, shape, and label,+ auto upd

    I am attaching a sample version now.
    Thank you for any help - my deadline is approaching soon and I am unable to solve this.

    By the way, I can click on a label outline near the point, and put in label options "value from cells"
    =map!$A$5:$A$205 which puts a label on the series point. However, if I delete the information for that specific series point later, titles go away. Also often times new series points do not automatically have that title (or shape, or color).

    Thank you
    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. Replies: 0
    Last Post: 12-04-2013, 04:51 PM
  2. Color Code Scatter data points
    By rnieman in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 07-22-2013, 11:34 AM
  3. Legend for scatter charts with color coded data points
    By Bernadine in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-26-2012, 10:32 AM
  4. Color code data points on a scatter chart (2007)
    By JayUSA in forum Excel General
    Replies: 11
    Last Post: 10-26-2012, 02:11 AM
  5. Replies: 0
    Last Post: 07-02-2012, 01:45 PM
  6. XY (Scatter) chart - 1 series/multiple color
    By KHUY in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-20-2012, 06:41 AM
  7. Scatter graphs - How do you label points?
    By nickbarthram in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-05-2007, 02:06 PM
  8. Data Points in Scatter Chart
    By CWILSON in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 01-26-2005, 10:07 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