Axes(xlCategory, xlPrimary).HasTitle = True Set rfp = Sheets(ws.Name).Range("G2", Sheets(ws.Name).Range("G2").End(xlDown))ĪctiveChart.FullSeriesCollection().Values = rfpĪctiveChart.FullSeriesCollection().XValues = rpv Set rpv = Sheets(ws.Name).Range("C2", Sheets(ws.Name).Range("C2").End(xlDown)) Worksheets(ws.Name).Range("E1").AutoFilter _ĪctiveChart.FullSeriesCollection().Name = ws.Name Is there another similar plot that I can generate much faster? Or can I speed up the generation of the box and whisker plot? I have 15 different sheets, with 4000 rows of data each. I wrote a macro to generate a box and whisker plot in excel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |