Hi, Konstantina.

Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.

-

1. Yes. 

The charts values will automatically update when you update the source table.

If you have a dataTable which is linked to source Excel file - when you update the source file, the table should update / as long as you maintain the table structure,

don't remove/add columns, don't change column headers or source file name, etc;

if you just update the rows basically.

-

In regards to a time interval when the table updates/refreshes, you can try our Cache and Auto-Update cache feature, by adding a Cron Job for auto updates.

Please check more how that is used here.

2. In regards to the "average" calculation for the Charts, 

i am sorry to disappoint you, but at the moment that is not possible.

Please feel free to search on our suggestions page, 

 to see if someone may be already suggested this feature. If you can't see it, feel free to add your suggestion there,  and as more people vote, the feature will move higher on the priority list.

You can certainly follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;

and our newsletter, so you're informed about new features, bug fixes, freebies, etc.

Hi, Konstantina.

Apologies for the waiting time.

I am truly sorry to disappoint you, but at this time we do not have any way to achieve an average calculation on our charts.

Our developers plan to work on it in the future, but i can't say a realistic ETA when it will be possible.

At the moment we just have "Grouping in Charts" as a SUM of values with same name.

-

We have an average calculation function for tables - but these calculations can not be passed to a chart currently.

And we do not have any custom workaround that we know of at the moment.

If you have coding skills and wish to try to make a custom solution now,

you can check out our available hooks for Developers on this documentation and see if you can find any hook that might help.

Please be advised that custom solutions with hooks are not included in our support.

You can also research resources such as Stack Overflow to see if any other user perhaps found a workaround.

( We do like to give examples for certain solutions, but for this use-case, we, unfortunately, don't have anything yet)