View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Raj[_2_] Raj[_2_] is offline
external usenet poster
 
Posts: 150
Default 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