+ Reply to Thread
Results 1 to 2 of 2

Skipping data in a chart

  1. #1
    Registered User
    Join Date
    10-31-2012
    Location
    Ohio
    MS-Off Ver
    Excel 2010
    Posts
    1

    Skipping data in a chart

    I have data with corresponding dates, the data box is becoming to large. Can I show only the every 3rd peice of data while retaining the line chart

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,481

    Re: Skipping data in a chart

    Simplest way is to filter the source data in such a way that only every 3rd data point is shown.
    Make sure the chart setting of 'Plot visible cells only' is enabled.
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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