Filter
Top Products
Using graphs in DataWindow objects
436 DataWindow .NET
Here is the resulting graph:
Notice that DataWindow Designer uses the literal “Total” supplied in the
Category box in the Graph Data window as a value in the Category axis.
Graphing actual and
projected sales
To graph total quarterly sales of all printers and projected sales for next year,
create a graph with the following settings on the Data page in the Properties
view (you assume that sales will increase by 10% next year):
•Set Rows to
All
•Set Category to quarter
• Set Value to sum(units for graph), sum(units*1.1 for graph)
• Select the Series check box
• Set Series to
'Actual','Projected'
You are using labels to identify two series, Actual and Projected. Note the
single quotation marks around the literals. For Values, you enter the
expressions that correspond to Actual and Projected sales. For Actual, you use
the same expression as in the examples above,
sum(units for graph). For
Projected sales, you multiply each unit sale by 1.1 to get the 10 percent
increase. Therefore, the second expression is
sum(units*1.1 for graph).