A
Athaydes
Hi, I have a few queries that I use to display data as graphs (pivotchart
view). I inserted all the graphs in a Form through Subforms (using the
queries directly as the source objects of the Subforms), so that each Subform
displays one query, always in pivotchart view.
My problem is that the colors of the graphs keep changing, and even worse,
the type of the graphs change.... two of my graphs are best viewed as pie
charts, but I save them as pie charts, and they just switch back to bar
charts when I open the Form again, and this makes the graphs look very
awkward.
I will appreciate any advice!!!
I am using Access 2003 under Windows XP. There's some simple VBA code behind
the Form, so that the time scales of the charts can be changed (with 'date'
text boxes in the Form) by the user (and on the Load event, automatically
dates are set to between current date and one year ago). The graphs
apparently started changing after I introduced this code, but the color
problem was happening before that.
view). I inserted all the graphs in a Form through Subforms (using the
queries directly as the source objects of the Subforms), so that each Subform
displays one query, always in pivotchart view.
My problem is that the colors of the graphs keep changing, and even worse,
the type of the graphs change.... two of my graphs are best viewed as pie
charts, but I save them as pie charts, and they just switch back to bar
charts when I open the Form again, and this makes the graphs look very
awkward.
I will appreciate any advice!!!
I am using Access 2003 under Windows XP. There's some simple VBA code behind
the Form, so that the time scales of the charts can be changed (with 'date'
text boxes in the Form) by the user (and on the Load event, automatically
dates are set to between current date and one year ago). The graphs
apparently started changing after I introduced this code, but the color
problem was happening before that.