Graph Legend

  • Thread starter Thread starter Alan
  • Start date Start date
A

Alan

Hi,

Hope I can get some help on this. I have used the Sum
function in a query to sum the values in four individual
columns A,B,C and D and then used the query as the basis
for a simple graph report. The query works perfectly, the
graph gets produced perfectly with one small problem - the
column headings automatically get called SumOfA, SumofB,
SumofC etc and these appear on the graph legend - I don't
want them to appear with these names on the legend, I want
to get rid of "SumOf" and just have them appear as A,B,C,D
on the graph legend but don't know how to do it.

TIA
 
Open the Row Source (query) of the graph control and alias the columns as
you desire. If you can't figure this out, come back with the SQL view of
your Row Source property.
 
Back
Top