Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Dynamically change chart legend on report?
- Thread starter gtroiano
- Start date
- Thread starter
- #2
FancyPrairie
Programmer
This might be a start:
- Thread starter
- #4
thanks for the reply. i already checked that. i've found out that you can't change the labels with the legend property but i thought that there might be another way of doing it. i was able to do it,throught code, by changing the row source of the chart but only on a form and not on report, as i would've liked. apparently, you cannot change the row source of a chart on a report. yet another problem.
jerry.
jerry.
FancyPrairie
Programmer
You can change the rowsource of the chart (sort of). Set the rowsource equal to a query. Then, when the user clicks on the button to print the report, prior to opening the report (which includes the chart), build the query (that the chart references) like you want and save it. Then open the report. The chart should display like you want it.
- Thread starter
- #6
that is what i have done but the labels in the legend are the column headings on the chart's datasheet which are in turn what is defined in the query(Sum(qryUGFederal.PreviousAmountU) AS [2000-2001]) where "2000-2001" is the column heading/legend label.
jerry.
jerry.
- Status
Similar threads
- Question
- Locked
- Question
