Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Las Vegas, Nevada, USA
    Posts
    334
    Thanks
    8
    Thanked 0 Times in 0 Posts

    Limits to the Number of Data Points in a Chart (Excel 2003)

    Is there a limit to the number of data points that can be displayed in a chart?
    I was hoping to display once-weekly data over a multi-year period but I had to resort to hiding or deleting rows to reduce the data displayed on a Line chart.

  2. #2
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Limits to the Number of Data Points in a Chart (Excel 2003)

    Yes there is...

    The image displayed is the limits in Excel 2007. I guess it will be a little less or the same in 2003. To get to this help, simply type LIMITS into the Excel offline help.
    Attached Images Attached Images
    Regards,
    Rudi

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Las Vegas, Nevada, USA
    Posts
    334
    Thanks
    8
    Thanked 0 Times in 0 Posts

    Re: Limits to the Number of Data Points in a Chart (Excel 2003)

    Thanks Rudy. Guess I coulda checked the other Help first but I like to come here for answers and ideas.
    I'll adjust the number of results in my Data series in one chart to 255.

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Limits to the Number of Data Points in a Chart (Excel 2003)

    XL2002 also has the 32,000 points which means you would be limited to only 615 years of data taken weekly <img src=/S/smile.gif border=0 alt=smile width=15 height=15>...


    Steve

  5. #5
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Las Vegas, Nevada, USA
    Posts
    334
    Thanks
    8
    Thanked 0 Times in 0 Posts

    Re: Limits to the Number of Data Points in a Chart (Excel 2003)

    Thanks Steve!
    On my first attempt I was trying to plot once-weekly data from 2000 to current in a 2-Axis line chart.
    By using your tip, I started with a 3-D chart then selected my second data set and changed that set to Chart-Type Lines on 2 Axes. This changed the entire chart from the original 3-D format to Lines on 2 Axes, which is exactly what I was looking for.

Posting Permissions

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