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!
"Duane Hookom" wrote:
> 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.
>
> --
> Duane Hookom
> Microsoft Access MVP
>
>
> "*Glen*" wrote:
>
> > 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*
> >
> >
> >
|
Similar Threads
