Graph Q (2003)

Topic

New Reply

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!

Reply | Quote

Replies

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.

Reply | Quote

Worked perfectly…thanks Hans!!

Reply | Quote

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!

Reply | Quote

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.

Reply | Quote

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

Reply | Quote