Results 1 to 5 of 5

Thread: Chart Data

  1. #1
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Columbus, Ohio, USA
    Posts
    286
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi all,

    Not sure if this goes in Access or in Excel

    My client has an MS Access application that calls MS Excel and then process a spreadsheet to create a chart. The problem is that the data points are bunched on the left side of the chart, not distributed as illustrated in the attachment. This problem has just begun within the past 3 weeks, according to the client. Any and all suggestions are welcome. TIA.
    Attached Images Attached Images

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    This probably means that the scale for the x axis (category axis) is not correct. Does it help if you set the minimum and maximum scale to automatic?


  3. #3
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Columbus, Ohio, USA
    Posts
    286
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi Hans,

    I'm not sure how or where to set those.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Double-click the x-axis, or click once on the x-axis and select Format | Selected axis, then activate the Scale tab.

  5. #5
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Columbus, Ohio, USA
    Posts
    286
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I think I found where to set the scale. The problem is finding the chart before it is output as a pdf. This will take some time. Thanks for the suggestion.

Posting Permissions

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