Automatic chart updating issue

Question

Hi,

I am facing issue with automatic chart update using Excel VBA. Actually I am running macro to update some data and with this data I am getting charts. Every time when data changes after running macro charts are not getting updated automatically. I have tried many ways like ".ResetAllPageBreaks" , ".Chart.Refresh" etc. But nothing happened.  

Another issue is that when I open this file then other files in which charts are getting auto updated, those files are also not updating.

Please help me to resolve this issue.

Thanks & regards,

Debangshu

Answer 1

I am asking any general procedure by which charts can be updated automatically.

Such a procedure did not exist in Excel.

Answer 2

Since it is broken, maybe now is the time to switch to PowerQuery to retrieve your data.

Use PQ to retrieve the data, load it to an Excel table, or even a PivotTable. Create the chart from that source.  By default the refresh is manual, just right click on the table or chart and select refresh.  There are ways to automate the refresh.

.

!   Power Query Overview: An Introduction to Excel’s Most Powerful Data Tool          2020 05 13   Jon Acampora

https://www.excelcampus.com/power-tools/power-query-overview/

https://www.youtube.com/watch?v=sIejxpsbI3A&feature=emb_rel_pause (15min51)

Learn how this awesome feature of Excel and Power BI called Power Query will help you automate the process of importing, transforming, and cleansing your data to save a TON of time with your job.

.  *  The Power Query Data Machine

.  *  Common Data Tasks Made Easy

.  *  Overview of the Power Query Ribbon

.  *  Unpivot Data for Pivot Tables

.  *  Append (Combine) Tables with Power Query

.  *  Merge Tables – A VLOOKUP Alternative

.  *  Create Custom Functions

.  *  PQ Records Your Steps & Automates Processes

.  *  The Power Query Machine & Power BI

!  The Complete Guide to Power Query         2018 02 11

https://www.howtoexcel.org/power-query/the-complete-guide-to-power-query/

Power Query is a business intelligence tool available in Excel that allows you to import data from many different sources and then clean, transform and reshape your data as needed.

It allows you to set up a query once and then reuse it with a simple refresh. It’s also pretty powerful. Power Query can import and clean millions of rows into the data model for analysis after. The user interface is intuitive and well laid out so it’s really easy to pick up. It’s an incredibly short learning curve when compared to other Excel tools like formulas or VBA.

The best part about it, is you don’t need to learn or use any code to do any of it. The power query editor records all your transformations step by step and converts them into the M code for you, similar to how the Macro recorder with VBA.

.  *  What Can Power Query Do?           .  *  Where is Power Query?

.  *  Importing Your Data with Power Query                .  *  Simple Example of Importing Data in a File

.  *  The Query Editor                  .  *  The Query List

.  *  The Data Preview                 .  *  The Applied Steps

.  *  The Formula Bar                   .  *  The File Tab

.  *  Data Loading Options            .  *  The Queries & Connections Window

.  *  The Home Tab            .  *  Difference Between Transform & Add Column Tabs

.  *  The Transform Tab               .  *  The Add Column Tab

.  *  The View Tab

.

@ Create Regular Excel Charts from PivotTables       2016 07 05https://www.myonlinetraininghub.com/create-regular-excel-charts-from-pivottables ****https://www.youtube.com/watch?v=5vOqZBmBRos (11min42)

PivotTables are a great way to summarise your data, but PivotCharts can be a pain in the, um, neck because...

.  *  They’re not as customisable as a regular Excel chart

.  *  They only play nice with data from one PivotTable

.  *  PivotCharts aren't available for all chart types e.g. Sunburst, Scatter, Histograms, Waterfall and more.

In this post I'm going to show you 3 methods you can use to trick Excel into creating a regular chart based on a PivotTable, allowing you to have all the benefits of PivotTables with the flexibility of regular charts.

.  *  Method 1: Manual Chart Table

.  *  Method 2: Dynamic Named Range

.  *  Method 3: Bait and Switch

.

@ 2007- Excel 2007 PivotTables and PivotChart (2007) 315pg  (downloaded) Peter G. Aitken

https://drive.google.com/file/d/0B0DBjBjJsSoLLUVCZ0xSbXp0ZDQ/view?usp=sharing

Part I: PivotTable FundamentalsCh 1: Understanding PivotTables and Charts 3

Ch 2: Understanding Data Sources for PivotTables 21

Ch 3: Using PivotTable Tools and Formatting 53

.

Part II: PivotTables and Charts: Going Beyond the BasicsCh 4: Working with PivotTable Components 87

Ch 5: More About PivotTable Components 137

Ch 6: Understanding and Using PivotCharts 165

.

Part III: Getting the Most out of PivotTables and ChartsCh 7: Using PivotTables with Multidimensional Data 191

Ch 8: Getting Hard Data from a PivotTable 211

Ch 9: PivotTable Alternatives  225

Ch 10: Programming PivotTables with VBA 241

@ **Create and Format a Pivot Chart in Excel 2010******http://www.dummies.com/how-to/content/how-to-create-and-format-a-pivot-chart-in-excel-20.seriesId-223716.html****After you create a pivot table in Excel 2010, you can create a pivot chart to display its summary values graphically. You also can format a pivot chart to improve its appearance.

.

Answer 3

I am asking any general procedure by which charts can be updated automatically.

Answer 4

You have a macro that we do not know in a file with data that we do not know and modify any diagrams we do not know and how they look like.

How do you think anyone in the world can help you with this information?

Andreas.