Bar Chart Question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Johnny C - 30 Nov 2005 14:59 GMT

I am creating a bar chart which contains a category for days of the week and
various values for data. I need to add a total bar that sums values for the
week. Total is not available from the dataset and the category, which is a
field from the dataset doesn't have a value for total either. Has anybody out
there attempted to built something like this?

Reply to this Message

Greg - 30 Nov 2005 15:53 GMT

I did a similar thing.

I made it available in the dataset by doing a
union select 'Total', Sum[theData]

This will add total to the column with the single value names which will
have the total value in the value column.

then it will automatically be in your graph.

Hopw that helps, explanation was a bit rubbish

>I am creating a bar chart which contains a category for days of the week
>and
[quoted text clipped - 4 lines]
> out
> there attempted to built something like this?

Reply to this Message