Pie Chart

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
Reply with the Row Source property of your chart so that we can possibly help.

Duane Hookom
 
SELECT [Class],Sum([Benchmark]) AS [SumOfBenchmark] FROM [Model Details]
GROUP BY [Class];
 
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


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



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

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

Duane Hookom said:
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


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



Duane Hookom said:
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.
Click to expand...
Click to expand...
Click to expand...
 
Reply back with your new SQL property that raises the error.

--
Duane Hookom
Microsoft Access MVP


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

Duane Hookom said:
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


awach said:
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.
Click to expand...
Click to expand...
Click to expand...
 
thanks, I got it figured out


Duane Hookom said:
Reply back with your new SQL property that raises the error.

--
Duane Hookom
Microsoft Access MVP


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

Duane Hookom said:
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.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top