Pivot Tables and Graphs (charts)
learnlearn52 wrote:
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.
Is the problem that your PT does not see the new data? Try defining the
PT range to include the entire columns, not just a rectangular range.
|