msadiqrajani
New member
- Local time
- Today, 15:43
- Joined
- May 11, 2011
- Messages
- 5
Hi All,
I one of my project I need to show a Pivot table and Pivot chart in a same report.
For now, I have created a PivotTable and PivotChart using this method:
techrepublic.com/article/add-a-pivot-chart-to-your-access-reports/6097020
And have successfully added in same report side by side.
But problem is that, If I filter PivotTable, its not updating PivotChart.I want to sync both, so when I update one, it also update other too.
Is it possible in Access or any other idea for achieving same result.
I one of my project I need to show a Pivot table and Pivot chart in a same report.
For now, I have created a PivotTable and PivotChart using this method:
techrepublic.com/article/add-a-pivot-chart-to-your-access-reports/6097020
And have successfully added in same report side by side.
But problem is that, If I filter PivotTable, its not updating PivotChart.I want to sync both, so when I update one, it also update other too.
Is it possible in Access or any other idea for achieving same result.