Who reckons charts are a pain to deal with?

[Guest]

I am trying to create a line chart in a report. The date is on the horizontal
access and I want the total number of hours on the vertical access. Each line
will be the total hours for each department on a weekly basis.

Two problems:

1) Each individual point is being represented by a "1" so the chart just
gives a straight horizontal line

2) How do I change the horizontal access to proper date format

 

[Duane Hookom]

Find and modify the Row Source property of the chart so it displays the
correct dates and numbers.

 

[Guest]

The source for the chart is a cross tab query. I don't have a clue what this
means!

TRANSFORM Count(*) AS [Count] SELECT (Format([WeekID],"WW 'YY")) FROM [Temp
total hrs_Crosstab] GROUP BY (Year([WeekID])*CLng(54) +
DatePart("ww",[WeekID],0)-1),(Format([WeekID],"WW 'YY")) PIVOT
[Administration];

Can you help?

 

[Guest]

I replaced the SQL from the row source with the SQL from the cross-tab query.
It is now ok (apart from some minor changes).

 

[Duane Hookom]

I don't know why the SQL is what it is. I don't see any field names that
suggest "hours". Change your Row Source to produce the values you want
graphed.

--
Duane Hookom
MS Access MVP

The source for the chart is a cross tab query. I don't have a clue what
this
means!

TRANSFORM Count(*) AS [Count] SELECT (Format([WeekID],"WW 'YY")) FROM
[Temp
total hrs_Crosstab] GROUP BY (Year([WeekID])*CLng(54) +
DatePart("ww",[WeekID],0)-1),(Format([WeekID],"WW 'YY")) PIVOT
[Administration];

Can you help?

Find and modify the Row Source property of the chart so it displays the
correct dates and numbers.