Create a Line Chart

[*Glen*]

I am having great difficulty trying to create a line chart in Access 2007. I
have a report with the following fields:

Staff_Component 1QTR 2QTR 3QTR 4QTR
Operations 10 28 45 33

Can someone please explain to me how I can create a line chart? Thanks and
Happy Holidays!

*Glen*

 

[Duane Hookom]

The report fields don't mean anything. You can generally add a chart control
to your report and use the wizard to set up your chart properties. I expect
you will need to update the Row Source property since the wizard often
clobbers it.

There should be a property that determines if your data displays horizontal
or vertical. You may need to change this since you have un-normalized data.

 

[*Glen*]

Duane,

I am very confused ;(

(1) What do you mean by "The report fields don't mean anything?"

(2) When I use the chart wizard, I can only choose up to 6 fields that
contain the data I want. This does not work for me because I need to plot 2
years of data (8 quarters) plus the staff component field.

(3) The chart is in a report. The report pulls data from a regular query
(not cross tab). Does this make a difference?

(4) Plotting the data in Excel is so simple but I can find hardly any
references on the web to help me with this.

(5) I could not find a property that will determine if data is displayed
horizontally or vertically.

(6)I took a stab at changing the row source property, but my SQL abilities
are not good enough.

(7) Please be advised that in my example below, the data format refers to a
report.

If I need to elaborate on anything, just let me know. This line chart is my
nemesis and it's all I want for Christmas!