Results 1 to 6 of 6
  1. #1
    destino is offline Novice
    Windows 10 Access 2016
    Join Date
    Apr 2017
    Posts
    2

    Cool Remove white space around a Chart object

    I want to place a chart on a report. I am finding that there is alot of white space around the actual report components. I want the actual report to extend to the edges of the enclosing box. It has to fit into a predefined location on the report and take up all the space allowed. I don't seem to be able find any attribute that allows this area to be reduced. All padding settings are set to 0. I have removed the legend and title as they are not required.
    Any suggestions would be gratefully received.

    Thanks

    Peter

    Click image for larger version. 

Name:	chart.png 
Views:	18 
Size:	7.8 KB 
ID:	28403

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    This can get tricky. Report in design view, double click on the graph control, click on the graph data area, click on the corner anchor and grab and drag. Might have to change font size.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    destino is offline Novice
    Windows 10 Access 2016
    Join Date
    Apr 2017
    Posts
    2
    Thanks for your help

    I've tried clicking and dragging every conceivable "draggable" point and it is still allowing excessive room for the legend and the horizontal axis title.

    Its very frustrating, I cant understand why the chart control in Access is so different from that found in excel. I have no issue doing what i require in excel.

    Peter

  4. #4
    Micron is online now Virtually Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    IMHO, charting in Access sucks like a vacuum cleaner. It will never improve as long as M$oft has a product they can sell you that does it very well. I gave up on it long ago and use Excel, pushing/pulling/linking the data from Access to Excel or vice versa.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  5. #5
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    As I said, tricky. Yes, Access doesn't have as sophisticated graphing but I have been able to get it to serve adequately for my needs. If you want to provide db I will take a look. Follow instructions at bottom of my post. If file too large for attaching to post, can upload to fileshare site and post link. I recommend Box.com.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  6. #6
    fredz is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2014
    Posts
    19
    I know this is an old post, but...

    Destino,
    Did u ever get a solution?
    I have the same problem.
    Fred
    Last edited by fredz; 01-29-2021 at 10:27 AM. Reason: typo

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

Similar Threads

  1. Remove white space and empty fields and label
    By mathanraj76 in forum Reports
    Replies: 2
    Last Post: 01-10-2017, 04:02 AM
  2. remove extra white space from duplicate field
    By ensorde in forum Reports
    Replies: 2
    Last Post: 10-01-2014, 08:31 AM
  3. White Space on Report
    By vansicklej in forum Reports
    Replies: 4
    Last Post: 07-31-2012, 12:00 PM
  4. Complicated white space question
    By raytackettsells in forum Access
    Replies: 12
    Last Post: 03-19-2012, 05:14 PM
  5. Remove White Space
    By jsimard in forum Reports
    Replies: 3
    Last Post: 01-24-2012, 12:16 PM

Tags for this Thread

Posting Permissions

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