473,652 Members | 3,045 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Pivot chart filter control

This is a bit of a two-part question.

1. Is there a way to control what filters are placed on a pivot chart
via vba.

I can easily change the underlying query and refresh pivot chart but
it's a big dataset and takes some time to load - my users are
impatient!

2. If this is not possible to code filters on the chart are the any
controls or properties that hold information about what filters are in
place.

e.g. A user opens the pivot chart and then using the field button drop-
downs selects a number of filters. Can I then find out what filters/
selection they have made, since I want to keep this information to use
later.

Cheers

Tom

May 15 '07 #1
1 6801
th************* **@gmail.com wrote:
This is a bit of a two-part question.

1. Is there a way to control what filters are placed on a pivot chart
via vba.

I can easily change the underlying query and refresh pivot chart but
it's a big dataset and takes some time to load - my users are
impatient!

2. If this is not possible to code filters on the chart are the any
controls or properties that hold information about what filters are in
place.

e.g. A user opens the pivot chart and then using the field button drop-
downs selects a number of filters. Can I then find out what filters/
selection they have made, since I want to keep this information to use
later.

Cheers

Tom
You might try looking for a book like the Excel Recipe Book. It has a
lot of Pivot Table Information. I think it might be possible to develop
a control to do the filtering that would interact with the Pivot Table.
Another method would be to develop multiple pivot tables with preset
filter controls that you can select with a button control to select a
specific Worksheet in a workbook. I think you can get this in an E-Book.

http://www.contextures.com/

I think this site has some files and some code you might look at also.
May 16 '07 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
3583
by: GoalieGW | last post by:
Does anyone know how to create a Pivot Chart at run-time? I have a database of meter readings that currently requires me to have 200 forms created so the user can enter date criteria and have a chart pop up. I would like to remove the forms and have them created at run-time. Any ideas?
2
2301
by: PC Datasheet | last post by:
From: "Martin" <Martin@discussions.microsoft.com> Subject: Pivot Chart Date: Monday, February 13, 2006 3:59 PM I am trying to learn how to use pivot charts. In 1995, if John took vacation 10/15 to 10/20, 11/9/ to 11/19 and 12/15 to 12/31, how would you set up the query and the pivot chart? Thank you!
1
2878
by: keliie | last post by:
Hello, I've created a form that contains a single unbound combo box and two subforms. The two subforms display the results of a query (driven by the combo box selection) in both tabular and pivot chart formats. The problem that I'm having is that the Pivot Chart that I've created rounds all of the values down to the nearest integer (e.g., 1.9 is rounded to 1.0, 0.6 is rounded to 0). As you can guess, this is a serious issue when I'm...
1
2515
by: mike11d11 | last post by:
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...
9
6787
by: PeteCresswell | last post by:
I've got something called "Reference Rates". The idea is that on a given day, we have various rates of return for various entities. e.g. Libor 3-month return, Libor 6-month return, US Treasury Bonds, the Prime rate, and so-forth. We associate a security with one of those rates. There are a set of rates for each calendar day, and the rates for that
1
3262
by: devagupt | last post by:
i have a form called get downtime data. WHen information is entered into it and the button "get downtime data" pressed , it displays the results of a query. WHen i view the query in pivot chart view , it only charts values which are over 1.Also , it displays only whole numbers and not decimal values like 2.3 etc.. I played with the scale tab in chart options and didnt get anywhere. I would like to display all values ( regardless of how small...
5
2505
by: fd1 | last post by:
Hi All, I created a pivot chart using Auto Form Pivot Chart. I'm trying to get to the RowSource query behind my chart but can't seem to locate it. I need to change the legend text. Any ideas? Thanks
0
2572
by: inepu | last post by:
Is there any way to show a field in a pivot table/chart that is calculated based on other fields of the pivot? I have the following table: Date; DescriptionField_1; Slots; EmptySlots I want to know the evolution of empty slots/slots ratio, and graph it on a chart; however, I need to be able to show the correct ratio as I drop and remove the DescriptionFields from the pivot. So I need that ratio field calculated based on the pivot...
1
5585
by: CoreyReynolds | last post by:
I can't find any information on this. If I have an existing query and I want to dump it into a page on a spread sheet and modify it as a pivot table all in VBA, can I do that? I only have the code so far (that works) to dump in the data and create a chart based off it... except I have to manually alter the data I dumped in into a pivot table for the chart to make sense every time.... it sure would be nice if VBA would do it for me! Heres...
0
8367
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8811
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8703
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8467
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8589
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
6160
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
4291
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2703
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
1591
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.