![]() ![]() News:*** Email address is removed for privacy ***. Add Name:="XSerN", RefersTo:="=XsN+"ĮrrMsg = "UserDefined Chart Not Available"ĪctiveChart.Appl圜ustomType ChartType:=xlUserDefined, _ĪctiveChart.Location Where:=xlLocationAsObject, Name:=ASNameĪctiveChart.SeriesCollection(1).Formula = _ Add Name:="YsN", RefersTo:="=" & YAddress & "" Add Name:="XsN", RefersTo:="=" & XAddress & "" YAddress As String, ASName As String, AWName As String, _ĪWName = "'" & ActiveWorkbook.Name & "'!" 'PBezucha, 2010 (basic idea Lori Miller ()ĭim Xs As Range, Ys As Range, XAddress As String, _ ![]() The sub is not entirely debugged for wrong selections. With chart to be inserted, much like as with common Chart Wizard, and trigger the macro. Series(1) should have a format of the final stage line, the format of Series(2) is arbitrary.įor creating an embedded dynamic stage chart in any workbook, keep this workbook with macro open, select the two ranges of x and y data in a worksheet You create it on the base of dummy data – follow the help on the topic. Still, I admire it as a result of almost hermetic science, as you can see on the definition of WB Names in the macro.Īll what you need here prepared is to have the user defined chart template, saved under the name “xyStageChart”. ![]() The neatest macro I have met, to produce stage plots without distorting original data, comes originally from Lori Miller (), I have only ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |