Charts

[D Willett]

Hi. I've used the chart wizard to create a chart based on 6 members of staff and resulting data. The chart is only returning results for one member which I am assuming is alphabetical. How do I create a chart which returns all results for all members of staff?

Cheers

[HansV]

What is the Row Source of the chart control?

[D Willett]

The row source of the chart control is:
SELECT [EstimatorCode],Sum([Notification to On Site]) AS [SumOfNotification to On Site] FROM [qryK2K-Summary] GROUP BY [EstimatorCode];
which is in the report footer.

The record source of the report is:qryK2K-Summary
SELECT qryK2K.EstimatorCode, Avg(qryK2K.[Notification-OnSite]) AS [Notification to On Site], Avg(qryK2K.[OnSite-Handover]) AS [On Site to Handover], Avg(qryK2K.[OnSite-InProgress]) AS [On Site to In Progress], Avg(qryK2K.[InProgress-Complete]) AS [In Progress to Complete], Avg(qryK2K.[Complete-Handover]) AS [Complete to Handover], Avg(qryK2K.[Notification-Invoice]) AS [Notification to Invoice]
FROM qryK2K
GROUP BY qryK2K.EstimatorCode;

[HansV]

What happens if you set the Row Source to qryK2K-Summary ?

[D Willett]

I still get one member of staff details but there are more bars of data.

[HansV]

Try changing the chart type.

[D Willett]

I think its because of the Link Master and Child properties. Leaving them blank returns my records !!
Cheers Hans