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

 

[Eric G]

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

Not quite.
I'm pretty happy with the four possible status field values:
(blank)
. (dot)
sus
oth

It's just when the circle graph is drawn, the status field values that
are blank are showing up on the graph _legend as "Slice 1". Can I
rename that?
Also, without changing the status field value ".", can I change the
legend name to "Attended".

Thanks! Eric

--
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

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.

--
Duane Hookom
MS Access MVP


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]

I think the values are linked and can't be different in the legend vs the
slice. If you always know what you want your legend to be then hide the
report legend and use text boxes or labels on your report.

--
Duane Hookom
Microsoft Access MVP

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

Not quite.
I'm pretty happy with the four possible status field values:
(blank)
. (dot)
sus
oth

It's just when the circle graph is drawn, the status field values that
are blank are showing up on the graph _legend as "Slice 1". Can I
rename that?
Also, without changing the status field value ".", can I change the
legend name to "Attended".

Thanks! Eric

--
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




On Mon, 29 Sep 2003 21:03:23 -0500, "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.

--
Duane Hookom
MS Access MVP


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

 

[Eric G]

OK thanks Duane.

I think the values are linked and can't be different in the legend vs the
slice. If you always know what you want your legend to be then hide the
report legend and use text boxes or labels on your report.

--
Duane Hookom
Microsoft Access MVP

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

Not quite.
I'm pretty happy with the four possible status field values:
(blank)
. (dot)
sus
oth

It's just when the circle graph is drawn, the status field values that
are blank are showing up on the graph _legend as "Slice 1". Can I
rename that?
Also, without changing the status field value ".", can I change the
legend name to "Attended".

Thanks! Eric

--
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




On Mon, 29 Sep 2003 21:03:23 -0500, "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.

--
Duane Hookom
MS Access MVP


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