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