A
Alan Z. Scharf
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 below.
The underlying query is returning all the required data rows.
If I reverse the sort order of column AssetVal, the first row of slice
data
is still dropped.
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
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 below.
The underlying query is returning all the required data rows.
If I reverse the sort order of column AssetVal, the first row of slice
data
is still dropped.
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