Access 2003 pie chart reporting incorrectly

[dawnd3]

I have a pie chart report, in an Access 2003 database, that I have selected the check box for the amounts and percentages to show for each of the slices. One of the slices is a negative number but it is showing a large piece of pie and a positive percentage as if the number was positive. There is a cooresponding report that has the same numbers, but in a table format, and the negative number correctly has a negative percentage. I need the pie to show either a negative percentage or 0 %. A positive percentage is simply incorrect math.

Is there a way to override the percentages show in the pie chart?

Thanks for your help.

Dawn

http://www.calliopeconsulting.net

 

[dhookom]

Change the results of your row source query to show the corrected values. Your graph will follow the Row Source query.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[dawnd3]

The query in the row source has the correct values. It is just the percentages that are being calculated incorrectly.

http://www.calliopeconsulting.net

 

[dhookom]

Are you suggesting that sending a negative number to a pie chart is a correct value? I would expect all values in a pie chart to be positive.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]