Making two pie charts look alike
Hi,
Data in two excel sheets is converted into pie charts on the same
sheet. I make changes to one pie chart to meet my requirements. I want
to make the second pie chart look exactly like the first. Is there a
UI way to do this (something like the format painter) or any VBA code
that I can use to make the second chart look exactly like the first
(colours, size, data categories display, borders etc)
Thanks in advance for the help
Regards,
Raj
|