Pivot Chart Slicers in Access

[shaylynch]

Hi All,
I'm a newbie to Access and I'm learning fast and enjoying it.. I've created a reporting tool in access where multiple users can report on issues in different areas of the business.. for reports i have created Pivot Charts and it works well however I was wondering can you attached Slicers to the charts as you can in Excel.

thanks in advance

Shay

 

[Smitty]

Unfortunately, Pivot Tables & Charts were deprecated in Access 2013, so you won't find any additional functionality.

You can easily use PowerPivot to link to your Access data in Excel where you do have Slicers. Or just query into Excel directly if your datasets aren't too big. I'd probably be thinking about that as a long-term solution anyway since if your organization upgrades you'll lose the current functionality anyway.

 

[shaylynch]

Hi Smitty
thanks for your response, apologies for late response, I've only seen it now..
I will do that thanks, and what I'm going to do is link one of the tables in access to a table in excel and use that for the source data for the pivot charts. I have one question that you may be able to help, how can I get access to
1. Open the workbook on a specific sheet ie. the Chart Sheet - as in use a button with a macro
2. and in same macro, to refresh the data in the table so as it opens the pivot charts and table are refreshed

thanks again for your response

Shay