Re: Missing pie slice

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 data*** 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
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>


.

Loading