A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How can I show multiple Pivotchart forms on the same screen at onc



 
 
Thread Tools Display Modes
  #1  
Old March 9th, 2010, 08:10 PM posted to microsoft.public.access.forms
dandc0711
external usenet poster
 
Posts: 14
Default How can I show multiple Pivotchart forms on the same screen at onc

I have a series of pivot charts created in Access and I'd prefer to be able
to show them all at once on one screen. Normally I'd do this in Excell since
it would be cake to sqeeze them all together but in this situation I need the
conditional formatting of pivot charts that access provides. So is there a
way to put all the charts on one "thing"?

I've tried putting them as subforms on a new form but they just come up
blank, same for trying to put them on a report.

-Thanks
  #2  
Old March 11th, 2010, 02:26 AM posted to microsoft.public.access.forms
Barry A&P[_2_]
external usenet poster
 
Posts: 119
Default How can I show multiple Pivotchart forms on the same screen at onc

Im sorry im not an expert on pivot charts but when you say Chart i believe it
is a report and you should be able to create all four of your pivot chart
reports and save them seperately and then create your master report with four
subreports based on your individual charts..

Sorry if this is way off base..
Barry


"dandc0711" wrote:

I have a series of pivot charts created in Access and I'd prefer to be able
to show them all at once on one screen. Normally I'd do this in Excell since
it would be cake to sqeeze them all together but in this situation I need the
conditional formatting of pivot charts that access provides. So is there a
way to put all the charts on one "thing"?

I've tried putting them as subforms on a new form but they just come up
blank, same for trying to put them on a report.

-Thanks

  #3  
Old March 12th, 2010, 04:14 PM posted to microsoft.public.access.forms
dandc0711
external usenet poster
 
Posts: 14
Default How can I show multiple Pivotchart forms on the same screen at

Unfortunatly, they are not reports but forms. The Create pivotchart option is
only availble in a form due to the custimization allowed in pivotcharts. I
tried doing something similar with a master form and subforms but the
subforms were just empty.

"Barry A&P" wrote:

Im sorry im not an expert on pivot charts but when you say Chart i believe it
is a report and you should be able to create all four of your pivot chart
reports and save them seperately and then create your master report with four
subreports based on your individual charts..

Sorry if this is way off base..
Barry


"dandc0711" wrote:

I have a series of pivot charts created in Access and I'd prefer to be able
to show them all at once on one screen. Normally I'd do this in Excell since
it would be cake to sqeeze them all together but in this situation I need the
conditional formatting of pivot charts that access provides. So is there a
way to put all the charts on one "thing"?

I've tried putting them as subforms on a new form but they just come up
blank, same for trying to put them on a report.

-Thanks

  #4  
Old April 15th, 2010, 06:16 PM posted to microsoft.public.access.forms
Barry A&P[_2_]
external usenet poster
 
Posts: 119
Default How can I show multiple Pivotchart forms on the same screen at

No idea if you are still working on this but i see it is still posted as
un-answered you are right a pivot chart is a form but it can be put on a
report by either dragging the chart from the database window to the reports
design view or use the Subform/Subreport control and choose an existing form.
you should be able to put them all on one report.. you may have to change
the link master fields property if the charts are not somehow linked to the
reports data but that should be easy enough..

Barry

"dandc0711" wrote:

Unfortunatly, they are not reports but forms. The Create pivotchart option is
only availble in a form due to the custimization allowed in pivotcharts. I
tried doing something similar with a master form and subforms but the
subforms were just empty.

"Barry A&P" wrote:

Im sorry im not an expert on pivot charts but when you say Chart i believe it
is a report and you should be able to create all four of your pivot chart
reports and save them seperately and then create your master report with four
subreports based on your individual charts..

Sorry if this is way off base..
Barry


"dandc0711" wrote:

I have a series of pivot charts created in Access and I'd prefer to be able
to show them all at once on one screen. Normally I'd do this in Excell since
it would be cake to sqeeze them all together but in this situation I need the
conditional formatting of pivot charts that access provides. So is there a
way to put all the charts on one "thing"?

I've tried putting them as subforms on a new form but they just come up
blank, same for trying to put them on a report.

-Thanks

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:34 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.