I have a graph, pulling data from Access. The fields used are named fldAreaI, fldAreaII, fldAreaIII, etc. When I create a graph, the labels show up as fldAreaI, etc. Is there a way to create a formula that renames them to "Area I Total", "Area II Total", etc.?
Additionally, I have another graph that is based on formulas. When the labels are included, they show up as "@AreaI", "@AreaII", etc. Is there a way to rename these so they're more descriptive, rather than using actual field names?
Additionally, I have another graph that is based on formulas. When the labels are included, they show up as "@AreaI", "@AreaII", etc. Is there a way to rename these so they're more descriptive, rather than using actual field names?