Re: Refreshing Chart

Don't know if the following applies to you. If not, you might want to
search the MSKB some more.

XL2002: Charts Do Not Update When Source Cells Are Updated
http://support.microsoft.com/defaul...kb;en-us;821644

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <BrianI.x915m@excelforum-nospam.com>,
BrianI.x915m@excelforum-nospam.com says...
>
> Hi
>
> I am using VBA code in Access to send revenue figures per month for the
> year to Excel there is a chart which shows this information already in
> Excel which just updates when the new information is sent. There is
> also calculated fields in Excel which calculate the revenue by quarter
> this is also graphed.
>
> The problem is that although the quarterly data updates when new
> information is sent, the graph which plots it does not. I have tried
> the .refresh command on the chart but this does nothing.
>
> Can anyone suggest anything ?
>
> Cheers
>
>
> Brian
>
>
> ------------------------------------------------
> ~~ Message posted from http://www.ExcelTip.com/
> ~~View and post usenet messages directly from http://www.ExcelForum.com/
>
>