ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Line chart in VBA - non trivial problem (https://www.excelbanter.com/charts-charting-excel/94467-line-chart-vba-non-trivial-problem.html)

Tomasz Klim

Line chart in VBA - non trivial problem
 
Hello

I have an existing line-chart with some data, and some [more] formatting. I
want to be able to create this chart from scratch, from blank sheet, using
VBA.

It would be enough to use Macro Recorder, manually recreate this chart, and
then get the macro code, but... it has advanced formatting, and is hard to
re-done.

So, do you maybe know a tool, that can "scan" existing chart, and generate
it's equivalent in VBA?

Something like "diff" tool, that compares blank sheet, and complete
chart/sheet/etc.

Thank you in advance!

tk




All times are GMT +1. The time now is 05:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com