An ActionGrid connected to an ActionViewChart to show in graph form all products and your quantity ordered by a customer

ActionViewChart XML Configuration

<?xml version="1.0" encoding="utf-16"?>
<SPSActionViewConfig>
  <DataBase ConnectionString=" ... " />
  <Query SelectCommand="SELECT SUM([Order Details].Quantity) AS Quantity, 
                               Products.ProductName
                        FROM   [Order Details] 
                        INNER JOIN Orders 
                              ON [Order Details].OrderID = Orders.OrderID 
                        INNER JOIN Products 
                              ON [Order Details].ProductID = Products.ProductID
                        WHERE Orders.CustomerID=@CustomerID  
                        GROUP BY Products.ProductName" />
  <Filter>
    <Param Name="CustomerID" Type="NChar" Default="" />
  </Filter>
</SPSActionViewConfig>

ActionViewChart XSLT

<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet version="1.0" 
                xmlns:xsl=http://www.w3.org/1999/XSL/Transform 
                xmlns:msxsl="urn:schemas-microsoft-com:xslt" 
                xmlns:sps=http://schemas.spsprofessional.com/WebParts/SPSXSLT 
                exclude-result-prefixes="msxsl sps">
  <xsl:output method="xml" indent="yes" />
  <xsl:template match="@* | node()">
    <!-- Graph -->
    <graph caption="Title" 

           xAxisName="Products" 

           yAxisName="Quantity" 

           decimalPrecision="0" 

           formatNumberScale="0">
      <xsl:apply-templates />
    </graph>
  </xsl:template>
  <!-- Each row -->
  <xsl:template match="Row">
    <!-- Put here your fields -->
    <set name="{ProductName}" value="{Quantity}" color="{sps:GetFcColor()}" />
  </xsl:template>
</xsl:stylesheet>