+ Reply to Thread
Results 1 to 3 of 3

Get rid of the actual data points

Hybrid View

  1. #1
    Registered User
    Join Date
    02-14-2010
    Location
    Preston England
    MS-Off Ver
    Excel 2007
    Posts
    23

    Get rid of the actual data points

    I'm sorry if this is all old hat. I cannot seem to get rid of the individual data points when making a graph from a set of data points. I end up with a nice graph but covered with nasty clunkey blobs. I want to remove them or reduce them in size, so that the actual curve is the centre of attention.

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP, 2007, 2024
    Posts
    16,460

    Re: Get rid of the actual data points

    I'm not entirely sure what you are asking.

    To remove the data markers from a line or scatter chart, select the series you want to format, enter the "format data series" dialog, select marker options, and choose "none". Your data series should now be formatted as a line without markers. Is that what you are trying to do?
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Registered User
    Join Date
    02-14-2010
    Location
    Preston England
    MS-Off Ver
    Excel 2007
    Posts
    23

    Re: Get rid of the actual data points

    Yes. Thank you. I must have completely missed the "none" option

    Quote Originally Posted by MrShorty View Post
    I'm not entirely sure what you are asking.

    To remove the data markers from a line or scatter chart, select the series you want to format, enter the "format data series" dialog, select marker options, and choose "none". Your data series should now be formatted as a line without markers. Is that what you are trying to do?

+ 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. Color chart data points/marker points vba error
    By nmckever in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-12-2014, 07:10 AM
  2. Replies: 0
    Last Post: 02-06-2013, 02:08 PM
  3. [SOLVED] converting X,Y chart points into actual coordinates
    By Alexander_Golinsky in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-21-2012, 04:34 AM
  4. Replies: 0
    Last Post: 10-08-2010, 12:29 PM
  5. Replies: 4
    Last Post: 05-30-2008, 10:39 AM

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