We have used Chartwell for some simple charts. But most of our charts are created from very detailed data over a period of ten years or more. For example, Chartwell cannot make a line chart with a fund, three indexes, and quarterly data over a forty year period. I wish it could.
Illustrator does this, but we must jump through a lot of hoops to clean up the data to make it work in Illustrator's archaic worksheet. For example, if we use dollar figures in a line chart, Illustrator will not accept those numbers with dollar signs on the front or commas separating the hundreds. So we have to clean up the numbers before the app will create the chart.