how to keep the oiginal format of charts intact in excel vba afterdeleting a series ??

V

vicky

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 .
 
P

Peter T

Answer would be different depending on whether you had applied your own
formats or accepted the default, amongst other things.

Rather than delete series, why not replace. Simply re-write the respective
series formulas as required.

Regards,
Peter T
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to format trendline as same color as series line in XL2007 0
How to chart data like this? 0
In excel scatter plot with 2 series, how do I connect xy coordinat 2
Ungrouping series to use secondary axis 0
Showing 2 series on the same chart 2
How to prevent Names of the Series being reset 0
Using SeriesCollection.Extend for a specific Chart Data Series 0
Is is me? Or is Excel 2007 Charting Lame? 13

Top