How to use Macro to control the chart?

[jefferyzhong]

hi,
I have a question which is about the chart report
my database requires optional report, for example, I need the report for certain department and certain shift, probably I need the report for all department and one shift. I can use Macro for data report. but it does not work for chart report!
can anyone tell me how to do it!

thanks in advance!

Jeffery

 

[jefferyzhong]

can anyone help?

thanks