Showing Crosstab Totals Column in Chart

I have the following crosstab query. I'd like to be able to put the Total Of
Amount on the secondary axis, but I can't figure out how. I appreciate your
help.

TRANSFORM Nz(Sum(Sales_All_qry.Amount),0) AS SumOfAmount
SELECT Sales_All_qry.Salesperson, Sum(Sales_All_qry.Amount) AS [Total Of
Amount]
FROM Sales_All_qry
GROUP BY Sales_All_qry.Salesperson
PIVOT Format([SaleDate],"mmm") In
("Jan","Feb","Mar","Apr","May","Jun","Jul","Aug"," Sep","Oct","Nov","Dec");

What is the exact Row Source property SQL view?
Is your chart set up to show months on the X axis and Amounts on the Y axis?
What value do you want to display on the secondary axis (the total for a
sales person)?

--
Duane Hookom
Microsoft Access MVP


"Alex" wrote:

I have the following crosstab query. I'd like to be able to put the Total Of
Amount on the secondary axis, but I can't figure out how. I appreciate your
help.

TRANSFORM Nz(Sum(Sales_All_qry.Amount),0) AS SumOfAmount
SELECT Sales_All_qry.Salesperson, Sum(Sales_All_qry.Amount) AS [Total Of
Amount]
FROM Sales_All_qry
GROUP BY Sales_All_qry.Salesperson
PIVOT Format([SaleDate],"mmm") In
("Jan","Feb","Mar","Apr","May","Jun","Jul","Aug"," Sep","Oct","Nov","Dec");