Pie chart form help

[guinness]

Hi All

Can anyone help me with the following

I have a pie chart showing what percentage of time is spent on which of four activities.

Got everything working however I would like the pie chart to ignore zero values so that if a person only spent time on two of the four activities the pie chart would only be made up of two slices but if they spent time on four activities it would show four slices. I hope this makes sense.

Cheers

Kev

 

[JHB]

Do you have some sample data, from where you get the data, and the data the chart use?

 

[guinness]

Hopefully he attachments make sense

So on the pie chart I don't want to see assessment as there are no hours recorded against this.

Any help appreciated

Kev

 

[JHB]

Are the data stored in the database as showed in table.jpg?
I wonder if it is possible to take 0% away, it should be possible if the result is not stored in the database like table.jpg but comming from a query.

 

[guinness]

Sorry for the confusion

I called the picture table jpg but what is actually displayed is a query not a table. The structure is that a table captures actual hours. These are summed on a query and then converted to percentages by another query which is then used to create the pie chart. What I need is some some sort of code to tell the pie chart to only display categories where the % is greater than zero.

I cant use >0 in the query as I do need to be able to show zero values however I want my pie chart to only show categories that have a value.

 

[JHB]

Sorry, but I don't think you can do that at this level.
If you have a column name, it will be showed in the graph.