Charts: Formatting: Lookup values

[Guest]

I have a chart that pulls the data from a table [SIP Details]. Using a pie
chart I'm showing the different status. The values on [SIP Details] are only
the reference number of the [Status] i.e. 1,2,3,4 and the actual status name
is on the [STATUS] table. Looking at the table [SIP Details] it shows the
actual status name since there is a lookup on the field, however on the pie
chart the status stown are 1,2,3,4.

This is the same as what happens on a report but on a report I just create
another field and do a lookup, but I can't seem to do that on a chart?

Can you help????

 

[Duane Hookom]

That's one of the reasons why many of us won't ever use lookup fields
http://www.mvps.org/access/lookupfields.htm.

The solution is to add the [STATUS] table in your chart's Row Source query.

BTW: Thanks for bracketing your table and field names. This little effort on
your part makes helping you much easier. I wish every poster would do the
same.

 

[Guest]

Thanks for your help - worked.

I have a problem with the legend, i.e. since the text is long it is wrapping
and I would like each series to be on one line. I have tried expanding the
legend box and while this works it goes over the pie chart. If I expand the
chart box then the pie chart grows bigger.

Can you help?

That's one of the reasons why many of us won't ever use lookup fields
http://www.mvps.org/access/lookupfields.htm.

The solution is to add the [STATUS] table in your chart's Row Source query.

BTW: Thanks for bracketing your table and field names. This little effort on
your part makes helping you much easier. I wish every poster would do the
same.


--
Duane Hookom
MS Access MVP

I have a chart that pulls the data from a table [SIP Details]. Using a pie
chart I'm showing the different status. The values on [SIP Details] are
only
the reference number of the [Status] i.e. 1,2,3,4 and the actual status
name
is on the [STATUS] table. Looking at the table [SIP Details] it shows the
actual status name since there is a lookup on the field, however on the
pie
chart the status stown are 1,2,3,4.

This is the same as what happens on a report but on a report I just create
another field and do a lookup, but I can't seem to do that on a chart?

Can you help????

 

[Duane Hookom]

Some of your options are:
- reduce the font size
- reduce the text that is too long
- add a field to your lookup table that is a short title
- live with it


--
Duane Hookom
MS Access MVP

Thanks for your help - worked.

I have a problem with the legend, i.e. since the text is long it is
wrapping
and I would like each series to be on one line. I have tried expanding the
legend box and while this works it goes over the pie chart. If I expand
the
chart box then the pie chart grows bigger.

Can you help?

That's one of the reasons why many of us won't ever use lookup fields
http://www.mvps.org/access/lookupfields.htm.

The solution is to add the [STATUS] table in your chart's Row Source
query.

BTW: Thanks for bracketing your table and field names. This little effort
on
your part makes helping you much easier. I wish every poster would do the
same.


--
Duane Hookom
MS Access MVP

I have a chart that pulls the data from a table [SIP Details]. Using a
pie
chart I'm showing the different status. The values on [SIP Details] are
only
the reference number of the [Status] i.e. 1,2,3,4 and the actual status
name
is on the [STATUS] table. Looking at the table [SIP Details] it shows
the
actual status name since there is a lookup on the field, however on the
pie
chart the status stown are 1,2,3,4.

This is the same as what happens on a report but on a report I just
create
another field and do a lookup, but I can't seem to do that on a chart?

Can you help????

 

[Guest]

I like your approach - live with it.

Some of your options are:
- reduce the font size
- reduce the text that is too long
- add a field to your lookup table that is a short title
- live with it


--
Duane Hookom
MS Access MVP

Thanks for your help - worked.

I have a problem with the legend, i.e. since the text is long it is
wrapping
and I would like each series to be on one line. I have tried expanding the
legend box and while this works it goes over the pie chart. If I expand
the
chart box then the pie chart grows bigger.

Can you help?

That's one of the reasons why many of us won't ever use lookup fields
http://www.mvps.org/access/lookupfields.htm.

The solution is to add the [STATUS] table in your chart's Row Source
query.

BTW: Thanks for bracketing your table and field names. This little effort
on
your part makes helping you much easier. I wish every poster would do the
same.


--
Duane Hookom
MS Access MVP

I have a chart that pulls the data from a table [SIP Details]. Using a
pie
chart I'm showing the different status. The values on [SIP Details] are
only
the reference number of the [Status] i.e. 1,2,3,4 and the actual status
name
is on the [STATUS] table. Looking at the table [SIP Details] it shows
the
actual status name since there is a lookup on the field, however on the
pie
chart the status stown are 1,2,3,4.

This is the same as what happens on a report but on a report I just
create
another field and do a lookup, but I can't seem to do that on a chart?

Can you help????

 

[Duane Hookom]

Quite a while back I worked with a network guru his first option in any plan
of action was "do nothing". We went on from there.

--
Duane Hookom
MS Access MVP

I like your approach - live with it.

Some of your options are:
- reduce the font size
- reduce the text that is too long
- add a field to your lookup table that is a short title
- live with it


--
Duane Hookom
MS Access MVP

Thanks for your help - worked.

I have a problem with the legend, i.e. since the text is long it is
wrapping
and I would like each series to be on one line. I have tried expanding
the
legend box and while this works it goes over the pie chart. If I expand
the
chart box then the pie chart grows bigger.

Can you help?

:

That's one of the reasons why many of us won't ever use lookup fields
http://www.mvps.org/access/lookupfields.htm.

The solution is to add the [STATUS] table in your chart's Row Source
query.

BTW: Thanks for bracketing your table and field names. This little
effort
on
your part makes helping you much easier. I wish every poster would do
the
same.


--
Duane Hookom
MS Access MVP

I have a chart that pulls the data from a table [SIP Details]. Using
a
pie
chart I'm showing the different status. The values on [SIP Details]
are
only
the reference number of the [Status] i.e. 1,2,3,4 and the actual
status
name
is on the [STATUS] table. Looking at the table [SIP Details] it
shows
the
actual status name since there is a lookup on the field, however on
the
pie
chart the status stown are 1,2,3,4.

This is the same as what happens on a report but on a report I just
create
another field and do a lookup, but I can't seem to do that on a
chart?

Can you help????