E
EJ
I am using an Autoform (pivotchart type) as a subform to display a graph. The
graph style is a line chart. I am using another form that contains date
pickers and combo boxes that allow the user to fill query parameters to get
specifc data. They then click a button to display the selected data in a form
that contains the chart subform. I would like to display the data lables on
the chart. It seems that because of the change in data (based on the
parameters) I can't get the data labels to stay "enabled" on the chart. Can
someone tell me how to "turn on" the datalabels using VBA after the pivot
chart loads? Thanks in advance.
graph style is a line chart. I am using another form that contains date
pickers and combo boxes that allow the user to fill query parameters to get
specifc data. They then click a button to display the selected data in a form
that contains the chart subform. I would like to display the data lables on
the chart. It seems that because of the change in data (based on the
parameters) I can't get the data labels to stay "enabled" on the chart. Can
someone tell me how to "turn on" the datalabels using VBA after the pivot
chart loads? Thanks in advance.