Missing pie slice

[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 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

 

[Echo S]

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?

 

[Alan Z. Scharf]

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

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

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

 

[Echo S]

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

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

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

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

 

[Alan Z. Scharf]

Echo,

That doesn't solve problem.

Alan

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

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

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


A slice is being consistently omitted from MS Graph pie chart in report,
with remaining data rows' Data label Percentage breakdown

re-balanced

as

 

[Echo S]

Well, nuts. I don't know what else would cause the first row to be dropped.

What if you pull (or send) the data into an Excel spreadsheet to create the
graph and then paste that into PPT? That might resolve it for you.

It sounds as if the Access chart is the issue -- have you asked in the
Access groups?

--
Echo [MS PPT MVP]
http://www.echosvoice.com

Echo,

That doesn't solve problem.

Alan

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

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


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


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

 

[Randy Hills]

just a quick thought, maybe a bad thought, its early before coffee.

Is it possible that the data sheet somehow had the first row set to
"exclude data"?

just a thought

Randy

 

[Alan Z. Scharf]

Randy,

Thanks for your reply.

I thihnk I know what is happening, I just don't know why.

Using the dataset below:

1. If I paste that into the datasheet in design mode, the pie chart
displays
correctly in Design mode.
2. However, if I then preview the Access report, with the underlying query
as the datasource for the chart, the first data row for 'US Long/Short'
is
missing as a pie slice.
3. I can reporduce this problem manually in design mode if I clear the
datasheet and then paste the five data rows into the datasheet starting
with
the very top row, i.e. overwriting the row with the column headings
'StyleName' and 'AssetVal'. In this case, the first row has the missing
pie
slice data, instead of the column names. Hence only the last four rows
are
used as data for the pie.

4. Conclusion: Somehow, it seems the query is doing the same thing as my
manually creating the problem, i.e. not placing the data in the datasheep
properly.

I checked the query and it works fine.

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

 

[Alan Z. Scharf]

Echo,

Thanks for your reply.

Excel didn't help.

Please see my response to Randy for what I believe is happening.

I tried one Access group with no response yet for a couple of days. Will
try another one.

Alan

Well, nuts. I don't know what else would cause the first row to be dropped.

What if you pull (or send) the data into an Excel spreadsheet to create the
graph and then paste that into PPT? That might resolve it for you.

It sounds as if the Access chart is the issue -- have you asked in the
Access groups?

--
Echo [MS PPT MVP]
http://www.echosvoice.com

Echo,

That doesn't solve problem.

Alan

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


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 th at
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


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


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

 

[Echo S]

Good detective work, Alan. Unfortunately, I don't know how to solve the
problem, though!

I hope someone in the Access groups has some ideas for you. Which group did
you post in?

 

[Alan Z. Scharf]

rked around it by adding extra dummy rows to table which will get
sorted to top, fill in the column name row, and push the first real data row
down to the pie slice No.1 row where it belongs.

Thanks for your help.

Regards,

Alan

Good detective work, Alan. Unfortunately, I don't know how to solve the
problem, though!

I hope someone in the Access groups has some ideas for you. Which group did
you post in?

--
Echo [MS PPT MVP]
http://www.echosvoice.com

Randy,

Thanks for your reply.

I thihnk I know what is happening, I just don't know why.

Using the dataset below:

1. If I paste that into the datasheet in design mode, the pie chart
displays
correctly in Design mode.
2. However, if I then preview the Access report, with the underlying query
as the datasource for the chart, the first data row for 'US Long/Short'
is
missing as a pie slice.
3. I can reporduce this problem manually in design mode if I clear the
datasheet and then paste the five data rows into the datasheet starting
with
the very top row, i.e. overwriting the row with the column headings
'StyleName' and 'AssetVal'. In this case, the first row has the missing
pie
slice data, instead of the column names. Hence only the last four rows
are
used as data for the pie.

4. Conclusion: Somehow, it seems the query is doing the same thing as my
manually creating the problem, i.e. not placing the data in the datasheep
properly.

I checked the query and it works fine.

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

 

[Echo S]

Glad to hear you got it worked out, Alan. Sorry we weren't really much help!