Graph question

[Eric G]

I can't believe I stumped everyone here. I'll try to ask my question
again.

I'm trying to get control of my circle graph in a report
using A2K and
would appreciate some tips.

The graph uses the data from one field in a table. The
field is called
status and can have one of four possible statuses
(blank, . (dot),
sus, or oth).

Right now my graph comes up with labels called:
Slice 1 (the blank one)
. (the dot)
Sus

There is no data currently with 'oth' so it isn't in the
graph yet.

How can I get in there and change the *names* of labels to
what I
would like?
For example I'd like to call 'Slice 1' Open
and I'd like to call the . (dot) Served

Thanks! Eric

 

[Duane Hookom]

Modify the Row Source query of your graph to display what exactly you want
displayed in your graph. If you get the Row Source to display it, the graph
will display it.

 

[Eric G]

Hi Duane,

Thanks for helping out!

My row source currently is:
SELECT [Status],Count(*) AS [Count] FROM [Detentions] GROUP BY
[Status];

This was automatically supplied when I used the wizard to create the
graph. It looks correct to me.
The graph is appearing correctly on the screen. I don't want to modify
the names of the values in the status field. They are working fine in
all of the associated queries I have.

I simply want the legend for the graph to have different labels than
what currently appears. Can the label names be changed without
changing the field values in the table?

Eric

 

[Duane Hookom]

Are you asking how to change the values of the status field to display some
other values in the graph?

--
Duane Hookom
MS Access MVP

Hi Duane,

Thanks for helping out!

My row source currently is:
SELECT [Status],Count(*) AS [Count] FROM [Detentions] GROUP BY
[Status];

This was automatically supplied when I used the wizard to create the
graph. It looks correct to me.
The graph is appearing correctly on the screen. I don't want to modify
the names of the values in the status field. They are working fine in
all of the associated queries I have.

I simply want the legend for the graph to have different labels than
what currently appears. Can the label names be changed without
changing the field values in the table?

Eric