Hi!
It is tricky, but doable.
1. Start new report in design mode
2. from the main menu, Insert Chart into detail section
3. The wizard will ask you to choose the data source for
the chart. Pick any table, with 4 or more columns if
posible
4. The wizard willask you for up to 6 fields for the
chart. Add any 6 fileds, at least one of them numeric.
Remember, it does not matter at this point what table and
what fields. This is just to create a graph on the
report. You will add real data in next steps.
5. The wizard will ask you to choose chart type. DO NOT
choose "scatter", choose "Line" instead
6. Select "Finish" in next step
Now you have a graph with Good knows what data (only
Microsoft knows that).
7. Select the graph object and open properties. In the
Row Source you will see something like "TRANSFORM Sum
([Quantity]) AS [SumOfQuantity] SELECT [ProjectID] FROM
[OrderItems] GROUP BY [ProjectID] PIVOT [CallRefNum];"
Microsoft thinks that every user will create PIVOT cross
tab) data set for every graph.
8. In query window build the query that returns the
points wou want to graph.
9. Switch to SQL window and copy (Ctrl C) the SQL
statemet, something like "SELECT tblMyGraphData.ValueX,
tblMyGraphData.ValueY
FROM tblMyGraphData;"
10. Paste the SQL statement into the graph's Row Source
property
11. Preview the report
12. To format your graph, go back to Design view for the
report, double click the graph. You will get Graph
related menu and excel like spreadsheet with some data.
You may change now the data type to Scatter
From excel-like sheet remove all columns on the right
side, leave only the first two. The first column is your
X values, the second is Y values. You may have up to 5
(6?) Y values (additional columns). Of course, column
titles you will see will be something Microsft put for
you (1stQuarter, 2ndQuerter etc). Do not worry, leave
them alone for a while, all be OK, no matter what they
say.
Trend lines: your Y values are likely the second column
of data in the excel like sheet. See what daat point
symbol is associated with it. On the graph, select that
symbol and right click it (any point). A menu will pop
up. Select "Add Trend line", then select the trend line
type. For thetrend line, you may choose in Options to
display the equation on the chart.
You have your graph.
Once you double click the graph, it is pretty much like
in Excel - you can do many things with it. You can change
formatting of the numbers in the excel-like sheet and
change the labels etc.
Experiment and have fun.
-----Original Message-----
I have a report that goups records into yeargroups, then shows totals for
"Pass", "Fail" and "No Test" and calculates the reliability by age group.
I need to build a scatter chart with a trendline based on these reliability
numbers. I can only find the procedures to buils a chart from tables and
queries. Any suggestions?
Brown
.
