View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
learnlearn52 learnlearn52 is offline
external usenet poster
 
Posts: 14
Default Pivot Tables and Graphs (charts)

Background:

I have a Pivot Table (PT) which is updated monthly. A chart is tied to the
data in the PT. The X-axis contains the months and the Y-axis contains the
respective data of the months.

Question: How can the chart be updated automatically (this should include
the latest monthly data) whenever the PT is updated (refreshed)?

Thanks in advance.