excel - Creating Dynamic Diagrams via VBA -


i tried create dynamic diagrams vba today. code works fine ive got problem line-diagram shows 10 out of 21 data series. code adds 21 data series via .newseries when code finished diagram shows 10 of them. has idea why happens or has solution problem?

activesheet.shapes.addchart2(, xlline, 0, 0, 1400).select dim cht chart set cht = activechart cht.haslegend = true cht.charttitle.text = "test"     activechart     until .seriescollection.count = 0         .seriescollection(1).delete     loop end   = 2 clmns step 4 activechart.seriescollection.newseries activechart.fullseriescollection(cnt).name = worksheets(1).cells(1, i) activechart.fullseriescollection(cnt).values = worksheets(1).range(worksheets(1).cells(1, i), worksheets(1).cells(rws, i)) cnt = cnt + 1 next 

greetings benjamin

i got solution, display bug, excel did not noticed there many data series. adjusted width , height little bit , refreshed diagram , series there. thank you.


Comments

Popular posts from this blog

php - Vagrant up error - Uncaught Reflection Exception: Class DOMDocument does not exist -

vue.js - Create hooks for automated testing -

Add new key value to json node in java -