Re: Missing pie slice

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Echo,

That doesn't solve problem.

Alan


"Echo S" <echos@xxxxxxxxxxxxxxx> wrote in message
news:OfYm2IQ8FHA.3224@xxxxxxxxxxxxxxxxxxxxxxx
> Ah, thanks. I'm obviously not up on my Access features. :-)
>
> What if you change the data orientation for the chart from column to row?
>
> --
> Echo [MS PPT MVP]
> http://www.echosvoice.com
>
>
> "Alan Z. Scharf" <ascharf@xxxxxxxxxxxxxx> wrote in message
> news:#WrM7uM8FHA.3592@xxxxxxxxxxxxxxxxxxxxxxx
> > DP is an Access Data Project, i.e. Access front end tied to MS SQLServer
> > database.
> >
> > In an Access Data Project, all Forms, Reports, and Program Modules are
> > stored in the Access .ADP file, while all data and queries (views) are
> > stored in SQLServer.
> >
> > Charting in Access works the same way whether the data is in an Access
> .MDB
> > file or Access .ADP file tied toSQLServer.. The SQLServer data source
> data
> > source is transparent to Access when creating a form, report, or chart.
> >
> > Looking at my question more broadly, is there anything in general that
> would
> > cause a pie chart not to be picking up a row of data, putting aside
> whether
> > the data is coming from an Access .mdb or SSQLServer?
> >
> > Thanks.
> >
> > Alan
> >
> >
> > "Echo S" <echos@xxxxxxxxxxxxxxx> wrote in message
> > news:#NWl7jI8FHA.956@xxxxxxxxxxxxxxxxxxxxxxx
> > > Can you clarify what you mean by "this is happening in ADP," but not
> using
> > > the same data and query in an Access database or the same data in
Excel.
> > > What is ADP?
> > >
> > > --
> > > Echo [MS PPT MVP]
> > > http://www.echosvoice.com
> > >
> > >
> > > "Alan Z. Scharf" <ascharf@xxxxxxxxxxxxxx> wrote in message
> > > news:O5Rx8tG8FHA.3044@xxxxxxxxxxxxxxxxxxxxxxx
> > > > A slice is being consistently omitted from MS Graph pie chart in
> report,
> > > > with remaining data rows' Data label Percentage breakdown
re-balanced
> as
> > > > if they were the only rows of data in the pie.
> > > >
> > > > This is happening in ADP, but not on same data and query in an .mdb
> > file,
> > > > or same data in Excel or PowerPoint chart..
> > > >
> > > > It is always the first slice data row, e.g. US Long/Short in data
set
> > > > below.below.
> > > >
> > > > The underlying query is properly returning all the required data
rows.
> > > >
> > > > If I reverse the sort order of column AssetVal, the first row of
slice
> > > > data is still dropped. That is, it is the first slice that's
missing,
> > > > whatever the sort order.
> > > >
> > > > Any idea where I can look to solve this?
> > > >
> > > > Thanks.
> > > >
> > > > Alan
> > > >
> > > >
> > > >
> > > >
> > > > The datasheet for the pie chart is
> > > >
> > > > StyleName AssetVal
> > > > US Long/Short $1,279,235,962.54
> > > > Global Macro $698,732,662.86
> > > > Cash & Other $534,771,158.10
> > > > Global Equity Long $438,678,247.72
> > > > Emerging Markets $192,987,295.78
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>


.

Relevant Pages

  • Re: Filter chart
    ... True, it does apply the filters to the record source for the report, but the ... chart row source, which uses the report record source, is not affected. ... filter property on your report. ...
    (microsoft.public.access.reports)
  • Re: RunSQL - MakeTable Query
    ... I have a form that opens on top of the report that once the user changes the ... depending on what the user picks as criteria for the chart. ... static RowSource, but the data underlying the RowSource needed to change ... In the SQL statement, I rename the fields from the original table ...
    (microsoft.public.access.formscoding)
  • Re: Obama feeling the heat
    ... I read the report. ... Even you should have been able to comprehend the nice chart ... The economy will turn itself around in spite of Obama's give ... Clearly you have turned this discussion away from economics to graphs rather ...
    (rec.sport.golf)
  • Re: RunSQL - MakeTable Query
    ... Today's problems don't worry me, ... I have a form that opens on top of the report that once the user changes ... depending on what the user picks as criteria for the chart. ... static RowSource, but the data underlying the RowSource needed to change ...
    (microsoft.public.access.formscoding)
  • Re: Obama feeling the heat
    ... Why is it not important that Obama's stimulus forecast ... I read the report. ... Even you should have been able to comprehend the nice chart ... The economy will turn itself around in spite of Obama's give ...
    (rec.sport.golf)