Modifying chart labels

[KerryL]

I have created a pie chart that represents the number of customer calls by region. The data is pulled from a query, which in turn references the request table. The problem is, the Region data fields in the table contains only the region numbers (1-8). So when the report is run, the data labels on the chart simply refer to the regions by number.

For example, the pct of calls from Region 1 is simply labeled "1" instead of "Region 1" and so on. Is there a way to add the word "Region" to what the query is already filtering and use it on the report so that the chart makes more sense?

I tried creating an expression in the query by using the following statement:
Expr1: "Region " & [tblCustomers].[Region]
but when I run the report, the pie chart shows just one large piece and is labeled "Slice 1."

How can I get data from a query that represents just the region number to show up on a chart as "Region #?"

Thanks in advance for any advice you can provide.

KerryL

 

[pdldavis]

Hi, In your query you might change
Expr1: "Region " & [tblCustomers].[Region]
to
Expr1: "Region #" & " " &[Region]

Hope that helps