+ 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

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

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

    Thank you for any help you can provide.

    1st, if necessary, I am fine with assigning a macro to accomplish this (if you can help with the macro code as I cannot code), as long as all users will be able to use this file. I would not be able to have users install an add-in or program.

    I am running Office 2013 and have made a scatter chart with 9 series. On the leftmost column is what I use for the label for each point, then y axis, and X axis is taken from the series column.

    http://imgur.com/V28hoo6 (the labels are in Japanese but I am a native English speaker - please just take them to be labels)
    http://imgur.com/1h8qmnV

    The series info is in a table. I want it to be where for each series I can assign a specific shape, color, and data label. It needs to update automatically so that I can put more entries in the table, and new points show up. The shape and color should be the same for each point in each series. (Series 1: all points blue squares. Series 2: all points yellow squares..) I am able to select a series point and add that information. It seems to apply the shape and color to the points already on the chart. However, if I later add info for another entry in the table, the color and shape are lost when a new point shows on the chart. This also happens for the data label. If I delete all the data points for a series, all the color, shape, and data label information disappears. If I then add a new point for the series, that color, shape, and data label info does not show up.

    How can I get this set up to retain the color, shape, and data label information so that users can enter and delete information and new data points show up formatted correctly?
    Thank you

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often 365, but still time to time use also older versions
    Posts
    8,018

    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

  3. #3
    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

  4. #4
    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

    Update: Now I am using a macro as I got it to work for adding labels.
    I used a sample online, so the names are like "film series" and so on, but it works
    in my file.
    2 things I would like the macro to do, now:
    1- have the label be in the center of the marker, not to the right
    2- (bigger part) - format the series markers. I have 9 series - I would like the series,
    by column, to be:
    (All: size 15)
    column d: blue, circle
    e orange, circle
    f yellow, circle
    g blue, triangle
    h orange, triangle
    i yellow, triangle
    j blue, square
    k orange, square
    l yellow, square

    Please Login or Register  to view this content.

  5. #5
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often 365, but still time to time use also older versions
    Posts
    8,018

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

    So it seems, that it takes care of your original question,
    If yes, please select Thread Tools from the menu link above and mark this thread as SOLVED.
    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. 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