Results 1 to 6 of 6

Thread: Graph Q (2003)

  1. #1
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Royal Oak, Michigan, USA
    Posts
    255
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Graph Q (2003)

    I want to plot a line graph showing the amount of production a new hire should accumulate over 18-months. I then want to show on a single point where new hires are in their current month of employment. The end result will be a single-line graph covering 18-months with individual points for each new hire showing where they are to target.

    Unfortunately, the chart options don't have a line - point combination. Does anyone have any tricks to help make this happen?

    Thanks!

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Graph Q (2003)

    The following assumes that you create the chart on a form. If you need it on a report, you should still create it on a form first, then copy it to the report when it looks the way you want.

    Create a line chart with two series: the target values and the employee values.
    Make sure that the chart control has Enabled = Yes and Locked = No.
    Switch to Form view.
    You should see two lines.
    Double click the chart to edit it.
    Select the target values series by clicking it or by selecting it from the Chart Objects dropdown on the toolbar.
    Select Format | Selected Data Series.
    Select None as Marker on the right hand side, then click OK.
    Select the employee values series by clicking it or by selecting it from the Chart Objects dropdown on the toolbar.
    Select Format | Selected Data Series.
    Select None as Line on the left hand side, and make sure that markers have been specified on the right hand side, then click OK.
    You should now have a combination of a line without marker points, and marker points without line.
    Click outside the chart to stop editing it.

  3. #3
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Royal Oak, Michigan, USA
    Posts
    255
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Graph Q (2003)

    Worked perfectly...thanks Hans!!

  4. #4
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Royal Oak, Michigan, USA
    Posts
    255
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Graph Q (2003)

    Hans,

    Is there an easy way to offset labels that may overlap? A few of the point labels sit right on top of each other and if there is a way to offset them, that would be great.
    Thanks!

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Graph Q (2003)

    No, not really. You might consider placing a data table below the chart instead of using data labels:
    - Double click the chart.
    - Select Chart | Chart Options...
    - Activate the Data Table tab.
    - Tick the check box.
    - Click OK.

  6. #6
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Royal Oak, Michigan, USA
    Posts
    255
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Graph Q (2003)

    That's what I thought. Not a problem and thanks again for your help!!

Posting Permissions

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