Results 1 to 8 of 8

Top ten data points in graph

  1. #1
    templeowls is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Feb 2019
    Posts
    45

    Top ten data points in graph


    I have a column in my table that has roughly 25-30 different values. Anyway to get a line or pie graph to only show the top 10? Just would look cleaner

  2. #2
    isladogs's Avatar
    isladogs is offline Very intense programming
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    3,463
    Have you tried SELECT TOP 10....
    Colin (Mendip Data Systems) : Website, email
    If this has helped, please click the star button and leave a comment

  3. #3
    templeowls is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Feb 2019
    Posts
    45
    I have not. How do I go about doing that?

  4. #4
    isladogs's Avatar
    isladogs is offline Very intense programming
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    3,463
    For the old style charts, go to design view, select your chart and click Edit.
    Select the record source and add TOP 10 after SELECT.
    OR if using a query, modify the query property sheet changing Select ...All to Top 10.

    If using the 'modern' chart option, you may need to adapt slightly.
    Colin (Mendip Data Systems) : Website, email
    If this has helped, please click the star button and leave a comment

  5. #5
    templeowls is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Feb 2019
    Posts
    45
    I'm in design view. There is no "edit" button anywhere to be found. Please be more specific on the instructions if you don't mind.

    Thx

  6. #6
    isladogs's Avatar
    isladogs is offline Very intense programming
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    3,463
    Certainly but you'll need to tell me whether you are using 'modern' charts or the traditional charts as the instructions will be different.
    Colin (Mendip Data Systems) : Website, email
    If this has helped, please click the star button and leave a comment

  7. #7
    templeowls is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Feb 2019
    Posts
    45
    I'm not exactly sure how to tell. I'm using Access 2016.

    Basically when I go to make a chart, I create a blank report and then go to design view and then "insert chart".

  8. #8
    isladogs's Avatar
    isladogs is offline Very intense programming
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    3,463
    Insert Chart on the Design toolbar is a 'modern chart.
    There's a very similar looking button in the bottom row of the Controls toolbox on the same ribbon - that brings up the older style chart dialog which is very different.

    Anyway... in design view click on your chart. The Chart Settings dialog will appear on the right.
    Select Data Source & select the table or query you used.
    Hopefully the Property Sheet will now be displayed. If not right click on the chart and select Properties at the bottom of the context menu.

    On the property sheet, select the small ellipsis button (...) to the right on the Row Source line.
    This should open your row source in SQL view - add TOP 10 after SELECT and click Close
    Or ..in query design view, change the Top Values line to Top 10 in the query property sheet.

    Hope that makes sense when you try it
    Colin (Mendip Data Systems) : Website, email
    If this has helped, please click the star button and leave a comment

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 7
    Last Post: 03-16-2019, 12:48 PM
  2. Replies: 1
    Last Post: 11-02-2015, 03:28 PM
  3. Replies: 3
    Last Post: 10-28-2014, 12:23 AM
  4. Exclude data points where fields are equal
    By jysupert in forum Queries
    Replies: 1
    Last Post: 09-02-2014, 03:30 PM
  5. Replies: 2
    Last Post: 06-24-2013, 12:37 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums