Hi Art, I used pivot charts extensively in the past(Access 2003) and also tried to control them via VBA(and succeeded for the most part except for a few intractable but somewhat marginal problems) so if you want to post your accdb I can take a look at it.
Giorgio
--- In MS_Access_Professionals@yahoogroups.com, Art Lorenzini <dbalorenzini@...> wrote:
>
> I can't seem to control the name of my series or display appropriate labels on my pie. I did get Sum Of changed to Count of thanks to Crystal.
>
>
>
>
> With warm regards,
>
> Arthur Lorenzini| SQL Server/Access Developer l alorenzin@...
> Office: 605-338-0947| Mobile: 605-857-9137 | Fax: 605-338-0947
> Â
> 1316 E. 7th Street
> Sioux Falls, SDÂ 57103 Â
> SQL Server Development
> Database Adminstration Services
> Microsoft Access Development Â
> Grant Writing TA Services
> IT Assessment Services
> Software Application Training
>
>
>
>
>
>
>
> From: Bill Mosca <wrmosca@...>
> To: MS_Access_Professionals@yahoogroups.com
> Sent: Wednesday, June 22, 2011 3:24 PM
> Subject: Re: [MS_AccessPros] Pie Chart in a form
>
> Â
> Art/John
>
> I played around with the pivot chart for the first time. There is a legend icon on the toolbar. Click it to see what each slice is.
>
> It's really kinda cool. Thanks for exposing this old dog to something he's never needed to know before.
>
> Regards,
> Bill Mosca, Founder - MS_Access_Professionals
> http://www.thatlldoit.com
> Microsoft Office Access MVP
> https://mvp.support.microsoft.com/profile/Bill.Mosca
>
> --- In MS_Access_Professionals@yahoogroups.com, Art Lorenzini <dbalorenzini@> wrote:
> >
> > This pivot chart is a really cool tool! I have it working. My question is there a way to add labels to the chart? So we know, like what percentage of each slice of the pie is and so on?
> >
> >
> >
> >
> > With warm regards,
> >
> > Arthur Lorenzini| SQL Server/Access Developer l alorenzin@
> > Office: 605-338-0947| Mobile: 605-857-9137 | Fax: 605-338-0947
> > ÂÂ
> > 1316 E. 7th Street
> > Sioux Falls, SD 57103 ÂÂ
> > SQL Server Development
> > Database Adminstration Services
> > Microsoft Access Development ÂÂ
> > Grant Writing TA Services
> > IT Assessment Services
> > Software Application Training
> >
> >
> >
> >
> >
> >
> >
> > From: John Viescas <john@>
> > To: MS_Access_Professionals@yahoogroups.com
> > Sent: Wednesday, June 22, 2011 11:15 AM
> > Subject: RE: [MS_AccessPros] Pie Chart in a form
> >
> > ÂÂ
> > Art-
> >
> > The easiest way is to use a PivotChart form. Start a new form using a query on
> > tblUnit that returns the fields of interest. Put the fields you need in Text
> > Box controls on the form, then switch to PivotChart view. (You could also make
> > PivotChart the default view while you're in Design mode.) You probably want to
> > chart for each Community and District, then include UnitID in the totals area
> > and ask it to count them. Choose Pie Chart for the type of chart, and you
> > should get the result you want.
> >
> > John Viescas, author
> > Microsoft Office Access 2010 Inside Out
> > Microsoft Office Access 2007 Inside Out
> > Building Microsoft Access Applications
> > Microsoft Office Access 2003 Inside Out
> > SQL Queries for Mere Mortals
> > http://www.viescas.com/
> > (Paris, France)
> >
> > -----Original Message-----
> > From: MS_Access_Professionals@yahoogroups.com
> > [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Art
> > Sent: Wednesday, June 22, 2011 5:22 PM
> > To: MS_Access_Professionals@yahoogroups.com
> > Subject: [MS_AccessPros] Pie Chart in a form
> >
> > I would like to display a pie chart on a form. I have a table called tblUnits
> > with some of the following structure:
> >
> > tblUnit
> > UnitID
> > Community
> > District
> > UnitStatus
> >
> > The UnitStatus field has two entries, its either vacant or occupied. I would
> > like to have the pie chart reflect these two entries for all units. Right now
> > there are 87 units that are vacant and 876 that are occupied
> >
> > Any ideas?
> >
> > Thanks
> >
> > Art Lorenzini
> > Sioux Falls, SD
> >
> > ------------------------------------
> >
> > Yahoo! Groups Links
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
> [Non-text portions of this message have been removed]
>
Tidak ada komentar:
Posting Komentar