Having problems with charts (access 2002-2003)

[Guest]

All,

I am sure that I am missing something basic here, but maybe someone can lend
a hand.

I am trying to insert a chart to my report. The horizontal data will be
dates (week ending dates) and the vertical data will be food and labor
costs. I ran into several problems.

1. If I had the field with the date formatted as a date, the chart would
only show the horizontal as monthly totals and I want this to be individual
dates. I put a bandaid on this by changing the field format to text from
date.

2. When the chart was showing monthly totals, it was also showing the food
and labor costs as sum totals. I need to see each total for the specified
week date and not a running total. I do not know why the chart defaults to
this as it is cokmpletely useless to most people.

3. The legend shows each (food and labor) cost as "sum of Labor" or "Sum of
Food" . I want this to state simply Labor or Food cost and do not want this
Sum of.

Can anyone help on this?

thanks
Mike

 

[Rick Brandt]

All,

I am sure that I am missing something basic here, but maybe someone can lend
a hand.

I am trying to insert a chart to my report. The horizontal data will be
dates (week ending dates) and the vertical data will be food and labor
costs. I ran into several problems.

1. If I had the field with the date formatted as a date, the chart would
only show the horizontal as monthly totals and I want this to be individual
dates. I put a bandaid on this by changing the field format to text from
date.

2. When the chart was showing monthly totals, it was also showing the food
and labor costs as sum totals. I need to see each total for the specified
week date and not a running total. I do not know why the chart defaults to
this as it is cokmpletely useless to most people.

3. The legend shows each (food and labor) cost as "sum of Labor" or "Sum of
Food" . I want this to state simply Labor or Food cost and do not want this
Sum of.

Unlike Excel Access' chart wizard assumes that you will use raw data as a data
source and will want the chart to do the aggregation. If you therefore use a
query that has already done the aggregation then the wizard is confusing to use.
You can change the Sum(field) to First(field) and it should give you what you
want.

Not sure I follow the part about "running total". I have never seen the chart
wizard produce a running total in its output.