Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to keep the oiginal format of charts intact in excel vba after deleting a series ??
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 "vicky" wrote in message ... 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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Fooling Excel on Time Series Charts | Charts and Charting in Excel | |||
Charts switch from 'Series in Rows' to 'Series in Columns' | Charts and Charting in Excel | |||
Keeping formula format intact | Excel Discussion (Misc queries) | |||
How do I plot multiple x-axis series in excel charts | Charts and Charting in Excel | |||
Excel Charts - Toggle Series On/Off | Excel Programming |