+ Reply to Thread
Results 1 to 3 of 3

Put a data series on a scatter chart in front of other data labels

  1. #1
    Forum Contributor
    Join Date
    11-13-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    279

    Put a data series on a scatter chart in front of other data labels

    Does anyone know how put a data series on a scatter chart in front of other data labels. I have two series. 1 has about one thousand values, but the other has just one. It is a different colour and shape, but unfortunately is snowed under the one thousand values. In idea how I can "bring to the front" my single data point, much in the same way as people can do with microsoft powerpoint?
    thanks

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,812

    Re: Put a data series on a scatter chart in front of other data labels

    See if changing the order of the data series (https://support.office.com/en-us/art...angesourcedata ) to the "first" (or "last") does what you want.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Forum Contributor
    Join Date
    11-13-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    279

    Re: Put a data series on a scatter chart in front of other data labels

    Perfect 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. [SOLVED] Data Labels on Scatter Plot VBA -- Looping through code for each data series
    By johnctholen in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-22-2015, 07:29 PM
  2. [SOLVED] Align Line Chart's data series Data labels on top of Bar chart data series
    By rgunlimited in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-01-2014, 10:38 AM
  3. Replies: 0
    Last Post: 04-01-2009, 10:54 AM
  4. Macro to add labels to data points in an xy scatter chart
    By Scott Wagner in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 12-16-2005, 09:50 PM
  5. Data point labels in XY scatter chart
    By TonyGB007 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-09-2005, 05:20 AM
  6. Data labels on scatter chart
    By rmellison in forum Excel General
    Replies: 3
    Last Post: 10-18-2005, 11:05 AM
  7. [SOLVED] Excel 2000 Scatter Chart cannot use data labels
    By Tom in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-06-2005, 02:06 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