By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,823 Members | 730 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,823 IT Pros & Developers. It's quick & easy.

Double Click bar in Pivot chart to export information

P: n/a
I was wondering if it was possible to export information from a pivot
chart when double clicking on the item I want. For example I have a
pivot chart with Four items in the legend and they are split up into
four categories on the chart. If I double click on one of the items in
one of the categories I want to export just the data for that item in
that category. Or if I double click on the item in the legend it will
export all the data for that legend item, preferably into excel.

Jul 31 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On 30 Jul 2006 18:45:23 -0700, "mike11d11" <mi*******@yahoo.com>
wrote:

No. Access reports are not interactive. Some interactivity is
promised for Access 2007; not sure if clicking on the legend is one of
them.
Your alternative is to create a new form to prompt the user to select
the item to export.

-Tom.
>I was wondering if it was possible to export information from a pivot
chart when double clicking on the item I want. For example I have a
pivot chart with Four items in the legend and they are split up into
four categories on the chart. If I double click on one of the items in
one of the categories I want to export just the data for that item in
that category. Or if I double click on the item in the legend it will
export all the data for that legend item, preferably into excel.
Jul 31 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.