insert a chart with VBA

[Nils_Junker]

Hi guys,

can somebody write me an VBA-Code for inserting a linechart(2D line chart)?
So my data is in "Tabelle 1" Range: D196:BD199, D208:BD211; D220:BD223.

in addition could you write to code so, that the graph is going to bo in the worksheet "Dashboard"

Thanks for your help!

 

[Dan_W]

Excel can write the code for you using the Macro Recorder. This guide will show you how: Automate tasks with the Macro Recorder - Microsoft Support

There may be some work in tidying up the code, but this should accomplish much of what you're trying to do.

Alternatively, Jon Peltier has an excellent blog which covers pretty much anything you could possibly want to know about VBA and charts: Quick Excel Chart VBA Examples