How to apply template script to a chart?

2 Views
Mattie Cobb
Answered 4 months ago
<p id="isPasted">I have created a dashboard. Sometimes the dynamic charts lose their format (when the slicer selections gets no data)</p><p>Once "good" data is selected, regular charts return to proper template, but dynamic charts are all messed up.</p><p>I wanna create a macro to reset the charts templates by applying saved templates. The macro isn't running.</p><p><br></p><p>ActiveSheet.ChartObjects("IncrementoMínimo").Activate</p><p>ActiveChart.ApplyChartTemplate ("C:\Users\danie\OlaKase\\Plantillas Gráficos\Incremento Mínimo.crtx")</p><p><br></p><p class="forexqa-img-container"><img src="https://prod-forexqna.s3.amazonaws.com/uploads/froala_editor/images/1744698021920.png" style="width: 730px;" class="fr-fic fr-draggable fr-dib forexqa-img"></p><p>I don't know why, it is working in another file.</p><p><br></p><p>ActiveSheet.ChartObjects("Gráfico 8").Activate</p><p>ActiveChart.ApplyChartTemplate ("C:\Users\danie\AppData\\Gráfico2.crtx")</p><p><br></p><p>The file where it's working ok: The dynamic chart is from a single table. All the data labels come from a dynamic table.</p><p>The file where …</p>