Pie Chart

[Guest]

I have a pie chart in a report that displays the percentage value next to
each slice. Some of the categories of the chart are sometimes zero,
depending on the product. Is there a way to have the chart only display
positive values and leave out the zeros? Thanks.

 

[Duane Hookom]

Modify the Row Source property of the chart to filter out the 0 values.

 

[Guest]

How would I do that?

Modify the Row Source property of the chart to filter out the 0 values.

 

[Guest]

Reply with the Row Source property of your chart so that we can possibly help.

Duane Hookom

 

[Guest]

SELECT [Class],Sum([Benchmark]) AS [SumOfBenchmark] FROM [Model Details]
GROUP BY [Class];

 

[Guest]

Try change the Row Source to:
SELECT [Class],Sum([Benchmark]) AS [SumOfBenchmark]
FROM [Model Details]
GROUP BY [Class]
HAVING Sum([Benchmark]) > 0;

--
Duane Hookom
Microsoft Access MVP

SELECT [Class],Sum([Benchmark]) AS [SumOfBenchmark] FROM [Model Details]
GROUP BY [Class];

Reply with the Row Source property of your chart so that we can possibly help.

Duane Hookom

 

[Guest]

That doesn't seem to work. It says that there is an error in the sql
statement.

Try change the Row Source to:
SELECT [Class],Sum([Benchmark]) AS [SumOfBenchmark]
FROM [Model Details]
GROUP BY [Class]
HAVING Sum([Benchmark]) > 0;

--
Duane Hookom
Microsoft Access MVP

SELECT [Class],Sum([Benchmark]) AS [SumOfBenchmark] FROM [Model Details]
GROUP BY [Class];

Reply with the Row Source property of your chart so that we can possibly help.

Duane Hookom
--
Microsoft Access MVP


:

How would I do that?

:

Modify the Row Source property of the chart to filter out the 0 values.

--
Duane Hookom
MS Access MVP

I have a pie chart in a report that displays the percentage value next to
each slice. Some of the categories of the chart are sometimes zero,
depending on the product. Is there a way to have the chart only display
positive values and leave out the zeros? Thanks.

 

[Guest]

Reply back with your new SQL property that raises the error.

--
Duane Hookom
Microsoft Access MVP

That doesn't seem to work. It says that there is an error in the sql
statement.

Try change the Row Source to:
SELECT [Class],Sum([Benchmark]) AS [SumOfBenchmark]
FROM [Model Details]
GROUP BY [Class]
HAVING Sum([Benchmark]) > 0;

--
Duane Hookom
Microsoft Access MVP

SELECT [Class],Sum([Benchmark]) AS [SumOfBenchmark] FROM [Model Details]
GROUP BY [Class];



:

Reply with the Row Source property of your chart so that we can possibly help.

Duane Hookom
--
Microsoft Access MVP


:

How would I do that?

:

Modify the Row Source property of the chart to filter out the 0 values.

--
Duane Hookom
MS Access MVP

I have a pie chart in a report that displays the percentage value next to
each slice. Some of the categories of the chart are sometimes zero,
depending on the product. Is there a way to have the chart only display
positive values and leave out the zeros? Thanks.

 

[Guest]

thanks, I got it figured out

Reply back with your new SQL property that raises the error.

--
Duane Hookom
Microsoft Access MVP

That doesn't seem to work. It says that there is an error in the sql
statement.

Try change the Row Source to:
SELECT [Class],Sum([Benchmark]) AS [SumOfBenchmark]
FROM [Model Details]
GROUP BY [Class]
HAVING Sum([Benchmark]) > 0;

--
Duane Hookom
Microsoft Access MVP


:

SELECT [Class],Sum([Benchmark]) AS [SumOfBenchmark] FROM [Model Details]
GROUP BY [Class];



:

Reply with the Row Source property of your chart so that we can possibly help.

Duane Hookom
--
Microsoft Access MVP


:

How would I do that?

:

Modify the Row Source property of the chart to filter out the 0 values.

--
Duane Hookom
MS Access MVP

I have a pie chart in a report that displays the percentage value next to
each slice. Some of the categories of the chart are sometimes zero,
depending on the product. Is there a way to have the chart only display
positive values and leave out the zeros? Thanks.