View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
vicky vicky is offline
external usenet poster
 
Posts: 52
Default how to keep the oiginal format of charts intact in excel vba afterdeleting a series ??

i have a line graph having two series SERIES1 AND SERIES2 . I AM
DELETING SERIES1 thru vba code and when i include that same series
i.e SERIES1 the formatting is going for a toss ,X Axis scale is
getting changed . i need a vba code which applys same formatting to
SERIES1 and also have same x axis scale which it had before deleting .