Displaying data in a chart

[emilesilvis]

Hi,



First post here.


I have a table that looks up values in two other tables. When I generate a chart based on a query selecting records from that table, the values used for the chart Axis and Series are from the ID column in the lookup tables, as opposed to the human-readable description column.

Can anyone advise?

Thank you in advance.

[NTC]

in your query; add/join in the source tables that contain the human readable fields - and put those fields into your query instead.

hope this helps.