Jan 18, 2012 at 9:54 PM
Edited Jan 18, 2012 at 9:56 PM
Charts are on the bottom of my list so don't wait for it. Right now I'm fixing bugs, next on the list are (in order) images on headers/footers, images anywhere, pivot tables (because I already have the skeleton to work on it), then charts. Sorry.
In the meantime you could try to create your chart using named ranges instead of hard coding them. That way ClosedXML should update the named ranges when you insert new rows and the charts should pick up on it.
Another option would be for you to pick up the ClosedXML code and modify it just enough to make the changes you want to the charts. Others have done it with pivot tables and comments (before I implemented them). Not saying it will be easy, but it's doable.
Check out Pitterling's code above.
A last resort would be to modify the file with ClosedXML and then modify the chart with another library like the OpenXML SDK.
I wish I had better news for you =/