Create a chart showing yearly values

  • Thread starter Thread starter RSunday
  • Start date Start date
R

RSunday

I would like to create a chart based on a query with data like:
Year x1 x2
1998 71 4
1999 84 5
2000 87 7
2001 102 6
2002 99 5

I would like the chart to be an area chart with the years on the x-axis and
the values "stacked" on the y-axis.

Can somebody guide me through the process in simple steps..?

When using the wizard I dont know what to select for data - if I select all
values (including the year) it is all shown as part of the area - and the
x-axis has some strange values. The drag and drop menu in the wizard is very
confsing - how do I indicate that I want two series stacked on the area?

Please help if possible.
 
I agree the wizard is quite confusing! This is the way to achieve the result
using Access 2000. I assume your data is in a table or query that has three
columns--
Year, Value1 and Value2.

In a report or form design view select Insert Chart object, which will kick
off the wizard. Select the table or query that has your data, and select all
three fields. Select the type of chart you want (you'll have to select side
by side bars initially, but it's easy to convert to stacked bar once this
section is over).

Now, here's the cunning bit. Make sure that the Year field is on the X axis
of the chart; the wizard will almost certainly have created a Y value
'SumOfValue1', or similar. Double click on this and change the 'Summarize'
value to 'None'. Now, drag the 2nd value on the right of the same dialog and
drop that on top of Value 1. The wizard will try and summarize that too, so
again, change the property to 'None'.

Your chart should now work, and if you need to change it to a stacked bar
then edit the graph object and just change the type.

Hope this helps.
Rob Ward
 
Back
Top