I have created a Pivot Chart that Graphs our orders per month and what
type of order they are, either Custom or Standard. To get the data we
use an input Form the uses a Combo Box to choose either Custom or
Standard when inputing.
Wehn I pull up the report with the Pivot Chart, the legend shows a
value of "1" for the Customs, and "2" for the Standards, The values
from the Combo Box.
How can I change the legend to read the Custom / Standard values
instead of the numerical values.