I want to change the source data path of a Pivot Chart that's pulling data
from an Access table. I tried following the KB at
http://office.microsoft.com/en-us/as...991761033.aspx but when I
click on "Get Data" it just shows the other tables in that database, where I
want to change the file it's reading from (same database name just different
path).

How do I do this?