Missing pie slice

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

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?
 
A

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


Echo S said:
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 said:
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
Click to expand...
Click to expand...
 
E

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


Alan Z. Scharf said:
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 said:
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 said:
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
Click to expand...
Click to expand...
Click to expand...
 
A

Alan Z. Scharf

Echo,

That doesn't solve problem.

Alan


Echo S said:
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 said:
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 said:
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
Click to expand...
Click to expand...
re-balanced
as
Click to expand...
Click to expand...
 
E

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


Alan Z. Scharf said:
Echo,

That doesn't solve problem.

Alan


Echo S said:
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 said:
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
Click to expand...
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
Click to expand...
Click to expand...
Click to expand...
 
R

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
 
A

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
 
A

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



Echo S said:
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


Alan Z. Scharf said:
Echo,

That doesn't solve problem.

Alan


Echo S said:
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
Click to expand...
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
Click to expand...
Click to expand...
Click to expand...
 
E

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?
 
A

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


Echo S said:
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


Alan Z. Scharf said:
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
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Missing Pie Slice in Pie Chart 6
Pie of Pie Chart: Grouping Rows 1
adding new data to pie chart 1
Any way to change pie chart legend order? 5
How can I reset the default pie chart label "Other" to "Equity"? 1
making 1 slice of pie chart 3-d 1
How to show parts of one slice of pie chart in Power Point? 4
Extra Slice in Pie in Pie chart 4

Top