excel charts - I want markers to skip data points

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: excel charts - I want markers to skip data points

  1. #1
    New Member
    Join Date
    Apr 2003
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default excel charts - I want markers to skip data points

     
    I have charts with lots of data points (3,000). The markers to identify series all run together since the data points are so close together. Is there a way to have the markers appear every 100 data points or so.

    Similar problem with dashed lines. My dashed lines appear as solids because the data points are so close together.

    Help. Thanks.

  2. #2
    MrExcel MVP tusharm's Avatar
    Join Date
    May 2002
    Posts
    11,007
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)

    Default

      
    Plot the few data points you want as markers as a 2nd series.

    For the first series, show the line but no markers. For the 2nd series, show the markers but no line.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com