![]() ![]() I have 2 tables: one that needs to be filled with the data from the mastersheet and the mastersheet. Shapes.AddChart2(408, xlBoxwhisker, 200, 100, 350, 200, True)ĪctiveSheet.Shapes(.Parent.Name).ScaleWidth 3, msoFalse, msoScaleFromTopLeftĪctiveSheet.Shapes(.Parent.Name).ScaleHeight 2, msoFalse, msoScaleFromTopLeft Set temp = ThisWorkbook.Worksheets("Sheet1") This can be simplified but for starters is it the right idea? Option Explicit Is this a problem of the BoxWhisker diagram? Or did I incorporate an error SetSourceData Source:=ActiveSheet.Range(ActiveSheet.Cells(2, 1), For the second chart, Excel reports the error: "Object does not support this action." The first diagram is created without any problems. Axes(xlValue, xlPrimary). = "Axe2"ĪctiveSheet.Shapes().ScaleWidth 3, msoFalse, msoScaleFromTopLeftĪctiveSheet.Shapes().ScaleHeight 2, msoFalse, msoScaleFromTopLeft Axes(xlValue, xlPrimary).HasTitle = True ![]() Axes(xlCategory, xlPrimary).HasTitle = True SetSourceData Source:=ActiveSheet.Range(ActiveSheet.Cells(2, 1), ActiveSheet.Cells(pEnd, 15)) I'm currently having a problem creating a boxplot chart in Excel temp.Activate
0 Comments
Leave a Reply. |