Creating a graph from exisiting data

[Richey]

I want to turn data into a graph (line graph for example) showing target and actual figures over 3 years
The table holds the relevant data as follows

Fieldnames data
Year1 yes
Year2 yes
Year3 yes
yr1target 100
yr1actual 90
yr2target 100
yr2actual 75
yr3target 85
yr3actual 50

I'd want the x-axis to be Year1, Year2, Year3
I'd want the y-axis to be figures (0 to 150 say)
I'd want the data to be 2 lines, namely the target and actual figures from the table

How would I go about constructing a graph for this?

Gwilym

 

[smoker1]

The best to do this is to create a report that has all your data in the report header.

Then,use the chart wizard to create the type of graph that you desire (the wizard really makes charting simple for first-time users).

At one point the wizard will ask you to arrange the data according to how you want it displayed. Simply drag the Year label onto the x axis and drag both the target and actual labels onto the y axis.

If you need to make simple adjustments to the chart once created, double-click the chart to open the chart options toolbars.

Hope that helps
Angela