Charts on forms

[Derek]

Hi Guys

I haven't worked with charts on Forms before and I am given a task to make a minor change in the already existing chart in Access Form. Please see attached the chart. The rowsource property of the chart is set to as below:

 SELECT tblstaff.[Staff Name], Sum(IIf([DateComp] Is Null And [DateDue]>=Date() And [DateDue]<=Date()+14,1,0)) AS Due, Sum(IIf([DateComp] Is Null And [DateDue]<Date(),1,0)) AS [Past Due]
FROM (tblstaff INNER JOIN tblAction ON tblstaff.[Staff Number] = tblAction.Owner) INNER JOIN tblProject ON tblAction.ProjectID = tblProject.ProjectID
GROUP BY tblstaff.[Staff Name], IIf([EndDate] Is Null,1,0), tblstaff.[End Date]
HAVING (((IIf([EndDate] Is Null,1,0))=1) AND ((tblstaff.[End Date]) Is Null))
ORDER BY Sum(IIf([DateComp] Is Null And [DateDue]<=Date()+14,1,0)) DESC;

I have to make a change i.e to display total of (Blue+Grey) of each bar on the top of each bar. So that means for David Packer , It should show 15 on the top of Bar. for Nick Smith, it should show 11 on the top of the bar. etc.

Can anyone let me know what do I need to do? Please see attached a "Copy of Book1" to have an idea what exactly I want but I have to use Access form for that.

Thanks

 

[Isskint]

Hi Derek,

Open the form in edit mode and double-click the chart so the chart designer interface opens up. From there you can select the type of bar graph you want, stacked in your case.

 

[Derek]

My question is how to display the total on the top of each bar. DO I need to change the rowsource ? What else I need to do? Thanks

 

[Isskint]

Data label options are also available from the chart designer interface. I do not have an example available, but i do not think it should not need rowsource changes.