legend in a chart (Access 2003)

  • Thread starter Thread starter Marta
  • Start date Start date
M

Marta

I created a chart using the wizard in a Form. The exercise ask me to open the
chart in design view and carry out alterations. One of them is to change the
Legend text. How can I do it?
 
Marta,
In chart design mode, select the Graph's Row Source query.
If you are plotting the values of field CarSales, and you want the
CarSales legend to read "Our Car Sales"...

In query design... (in the Field location)
Our Car Sales: CarSales

In SQL
SELECT.... tblAllCarSales.CarSales AS [Our Car Sales]......
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."
 
Sorry Al
I didn't explain myself well.
The chart is created in a Form using the Chart Wizard in the object Form,
the legend just says SumOfSales Value and I have to change this text to read
Total Sales. I pressed F1 and it's written to click in the legend where the
text is and easily change it, but I can't. Thank you very much.
 
Thank Al! I found the solution.
Right click, "properties", "row source" and change there the text to Total
Sales.
Have a good day!

Al Campagna said:
Marta,
In chart design mode, select the Graph's Row Source query.
If you are plotting the values of field CarSales, and you want the
CarSales legend to read "Our Car Sales"...

In query design... (in the Field location)
Our Car Sales: CarSales

In SQL
SELECT.... tblAllCarSales.CarSales AS [Our Car Sales]......
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

Marta said:
I created a chart using the wizard in a Form. The exercise ask me to open
the
chart in design view and carry out alterations. One of them is to change
the
Legend text. How can I do it?
Click to expand...
Click to expand...
 
Good deal... the legend text is in the query behind the graph...
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

Marta said:
Thank Al! I found the solution.
Right click, "properties", "row source" and change there the text to Total
Sales.
Have a good day!

Al Campagna said:
Marta,
In chart design mode, select the Graph's Row Source query.
If you are plotting the values of field CarSales, and you want the
CarSales legend to read "Our Car Sales"...

In query design... (in the Field location)
Our Car Sales: CarSales

In SQL
SELECT.... tblAllCarSales.CarSales AS [Our Car Sales]......
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your
life."

Marta said:
I created a chart using the wizard in a Form. The exercise ask me to
open
the
chart in design view and carry out alterations. One of them is to
change
the
Legend text. How can I do it?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top