A
AccessARS
I have been searching for a way to display a charts datasheet with the legend
colors next to each row in my form/report.
Currently I have charts with legends on forms and reports along with
corresponding details displayed below the charts in a subform/subreport. The
legend of the chart displays the appropriate colors and value but I also need
to display two additional columns which is the reason behind having the
subform/subreports. Unfortunately in the sub details I have to repeat the
legend values next to the other columns for reference. It would be ideal if
I could display the legend colors next to each row in subform/subreports or
an alternative method just like you would see it in the datasheet of the
chart/graph and get rid of the legend all together.
During my research on the limited Access Charting I’ve come across the MS
Graph Object with some promising Graph_Data.Application.DataSheet....
properties but have not yet figured out a solution.
Any type of lead would be much appreciated. Thank you in advance for your
time.
colors next to each row in my form/report.
Currently I have charts with legends on forms and reports along with
corresponding details displayed below the charts in a subform/subreport. The
legend of the chart displays the appropriate colors and value but I also need
to display two additional columns which is the reason behind having the
subform/subreports. Unfortunately in the sub details I have to repeat the
legend values next to the other columns for reference. It would be ideal if
I could display the legend colors next to each row in subform/subreports or
an alternative method just like you would see it in the datasheet of the
chart/graph and get rid of the legend all together.
During my research on the limited Access Charting I’ve come across the MS
Graph Object with some promising Graph_Data.Application.DataSheet....
properties but have not yet figured out a solution.
Any type of lead would be much appreciated. Thank you in advance for your
time.