Who reckons charts are a pain to deal with?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Find and modify the Row Source property of the chart so it displays the
correct dates and numbers.
 
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?
 
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).
 
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


scubadiver said:
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?

Duane Hookom said:
Find and modify the Row Source property of the chart so it displays the
correct dates and numbers.
Click to expand...
Click to expand...
 
Back
Top