adding values in stacked bar chart

fh_freese,

Basically You need to also plot the total (AssemblyPerUnit + TotalHousing) as a dummy series.

Here is a sample.

Let me know if it is what you wanted

JeffCoachman
Access-EEQ23433478AddTotalSumToS.mdb

this looks to be exactly what i wanted - i'll study it and let you know, many thanks

boag200:
Here's my changes but I did not get any data. I added the UNION statement and tried to add values. Please comment.

SELECT tblDailyProduction.ProductionDate, qryDiffCarrierCasePerUnitB26.[CarrierCasePerUnitB26] AS [Carrier Case], qryDiffCasePerUnitB26.[DiffCasePerUnitB26] AS [Diff Case], qryPerUnitBuildTimeStdDiffCarrierAssemblyB26.DiffCarAsemblyBuildTime AS [Diff Assembly]
FROM (qryPerUnitBuildTimeStdDiffCarrierAssemblyB26 INNER JOIN (qryDiffCasePerUnitB26 INNER JOIN qryDiffCarrierCasePerUnitB26 ON qryDiffCasePerUnitB26.ProductionDate = qryDiffCarrierCasePerUnitB26.ProductionDate) ON qryPerUnitBuildTimeStdDiffCarrierAssemblyB26.ProductionDate = qryDiffCasePerUnitB26.ProductionDate) INNER JOIN tblDailyProduction ON qryDiffCarrierCasePerUnitB26.ProductionDate = tblDailyProduction.ProductionDate
WHERE (((tblDailyProduction.ProductionDate) BETWEEN [Forms]![frmDailyReport]![txtStartDate] AND [Forms]![frmDailyReport]![txtEndDate]))
GROUP BY tblDailyProduction.ProductionDate, qryDiffCarrierCasePerUnitB26.[CarrierCasePerUnitB26], qryDiffCasePerUnitB26.[DiffCasePerUnitB26], qryPerUnitBuildTimeStdDiffCarrierAssemblyB26.DiffCarAsemblyBuildTime;
UNION Select Total, Sum(qryDiffCarrierCasePerUnitB26.[CarrierCasePerUnitB26] + qryDiffCasePerUnitB26.[DiffCasePerUnitB26] + qryPerUnitBuildTimeStdDiffCarrierAssemblyB26.DiffCarAsemblyBuildTime);

fh_freese,

Can you post the output of this query?

Turn it into a MakeTable Query.
Run the Make Table query.
It will create a tbals that I can work with.
Put the table in a sample DB and post it here.

JeffCoachman

Jeff:
I will honor your request but it will need to be tomorrow -
Many thanks for hanging with me!
Frank

Jeff,
Here's the compressed file. There is one form frmDailyReport to excute. It will launch the report in preview. I noticed another problem in that my scale reads:
0
1
1
2
2
3
3
4
Which I do not know why. The first need was to add totals in the stacked bar chart and the second is the scale. Thanks for looking into this. All queries have been include. The date range is 5/1/08 - 5/23/08 in the frmDailyReport
stacked-bar-total.zip

Thanks,

I will look at this tonight

JeffCoachman

Do not look at the scale problem....I solved it by simply changing the number format to include a decimal. That;s solved. Many thanks...good luck

Your file seems to have locked my computer,

I will reboot an try again tomorrow

Let me resend the file. I may have forget to set some of the relationships in my queries. This happened to me but I thought you got a good file. I apologize.
stacked-bar-total.zip

fh_freese,

No, it was not your file, it was my computer.
I've been having trouble with lockups since upgrading to IE7

Jeff

Jeff,
I have found a solution to placing totals above a stacked bar chart. Interested?

sure

I kept looking at your solution as it related to what I was wanting to do. It dawned on me that Access provides the data but when a graph is required ownership of the formatting is passed to Excel. The solution was found at:

http://www.andypope.info/charts/StackColTotal.htm

Although this is excel when as I followed these step I got exactly what I wanted.