Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Jun 2001
    Thanked 0 Times in 0 Posts

    Line chart (2000 SP-3)


    I'm trying to create a line chart but it doesn't come out anywhere near what I need. I walked through the wizard and came up with the attached file. The general layout is good but there are still these problems:

    -- Not all employees are showing (the horizontal axis).

    -- The data looks compressed. I'd like the chart a lot larger but I can't change it in the Design view.

    -- I can't fix the legend names. Right now, they are the field names from the table--I'd like something more descriptive.

    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 28 Times in 28 Posts

    Re: Line chart (2000 SP-3)

    Double click the chart in design view. You probably won't see the actual data, but you will be able to change the size of the chart area. It's best to select Format | Selected Chart Area before resizing, and clear the Auto Scale check box in the Font tab. If you make the chart area wider, all employee names should be displayed.

    To fix the legend, you will probably have to provide aliases for the field names in the query that acts as data source for the chart.

Posting Permissions

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