PDA

View Full Version : Think Cell - Edit Bar Chart



asingh
12-29-2015, 01:59 AM
Has anyone here worked on Think Cell (https://www.think-cell.com/en/). We have automated a tool where the graphs are created using Think Cell and generated in PPT. The deal is to format the Think Cell charts before they are pasted into the PPT template. Basically a pre-fabricated PPT is launched with Think Cell charts and our program supplies the updated Excel range to the charts to update. The charts are updating fine, what we want is: one specific bar on the Think Cell bar chart gets colored orange. Am not able to find any code around this.

Using the thinkcell COMADDIN we use the UpdateChart method to populate the new ranges.

Any help around this would be great...! Thanks to all.