Pivot Charts on Web not working
 

I have published pivot chart with interactive option checked but it
never worked fine. Viewing the page on web shows this error message:


Failed to get data. If available, errors returned from the provider
are listed below.
* Error opening data file *
{file_path_xxx_cahce.xml}


Can any one specify what is the problem, how to resolve it and how can
I show pivot charts interactively on web. Seems that pivot charts need
to generate xml cache file but how they will generate, should I publish
it on some server ? I am using Office 2003 with all updates on my
system and viewing page from my local system (not hosted on any
website).