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

In excel scatter plot with 2 series, how do I connect xy coordinat 2
Using SeriesCollection.Extend for a specific Chart Data Series 0
Showing 2 series on the same chart 2
How to change Series order in a Combination Chart? 3
How to select numeric 'series axis' in a surface chart? 4
VBA to identify the name of a point 3
VBA to identify the name of a point 3
iterate through chart series collection 8

Top