It is currently April 27th, 2024, 11:09 pm

Excel graph display on windows desktop

Get help with installing and using Rainmeter.
hernou31
Posts: 2
Joined: January 15th, 2024, 3:20 pm

Excel graph display on windows desktop

Post by hernou31 »

Bonjour, est-il possible d'afficher avec Rainmeter, un graphique excel sur le bureau Windows, qui se mette à jour automatiquement en fonction de l'actualisation de la feuille de calcul qui y correspond ? Merci d'avance si vous avez des solutions.

"Hello, is it possible to display with Rainmeter, an excel chart on the Windows desktop, which updates automatically according to the refresh of the corresponding spreadsheet? Thanks in advance if you have any solutions."
Last edited by eclectic-tech on January 15th, 2024, 3:48 pm, edited 1 time in total.
User avatar
balala
Rainmeter Sage
Posts: 16182
Joined: October 11th, 2010, 6:27 pm
Location: Gheorgheni, Romania

Re: Excel graph display on windows desktop

Post by balala »

hernou31 wrote: January 15th, 2024, 3:40 pm Bonjour, est-il possible d'afficher avec Rainmeter, un graphique excel sur le bureau Windows, qui se mette à jour automatiquement en fonction de l'actualisation de la feuille de calcul qui y correspond ? Merci d'avance si vous avez des solutions.

"Hello, is it possible to display with Rainmeter, an excel chart on the Windows desktop, which updates automatically according to the refresh of the corresponding spreadsheet? Thanks in advance if you have any solutions."
No, unfortunately this is not possible. Rainmeter can't deal with Excel spreadsheets. There might be some software tool out there to get the spreadsheet in a form to can be displayed by Rainmeter, but unfortunately I can't recommend one and have no knowledge of such a tool.
Sorry...
User avatar
Yincognito
Rainmeter Sage
Posts: 7178
Joined: February 27th, 2015, 2:38 pm
Location: Terra Yincognita

Re: Excel graph display on windows desktop

Post by Yincognito »

hernou31 wrote: January 15th, 2024, 3:40 pm Hello, is it possible to display with Rainmeter, an excel chart on the Windows desktop, which updates automatically according to the refresh of the corresponding spreadsheet? Thanks in advance if you have any solutions.
Yes, it is possible, but you'll have to help Rainmeter do that from the Excel's VBA code - mainly, exporting / saving what you need from that spreadsheet / workbook (e.g. data or images), so that the Rainmeter skin can display it.

An example on how to do that when data is concerned, in this thread:
https://forum.rainmeter.net/viewtopic.php?t=35943&start=10#p182380

When it comes to charts though, you have two options:
- save the chart as an image from the sheet's VBA and then display the image in the skin using an Image meter
https://docs.rainmeter.net/manual/meters/image/
- export the data from the sheet using VBA and then create the graphic yourself in the skin, using Shape meters
https://docs.rainmeter.net/manual/meters/shape/

Of course, this is a relatively complex process for a beginner in Rainmeter (it does help if you're proficient with Excel and VBA though, since that solves half of the problem), but since you asked... 8-)
Profiles: Rainmeter ProfileDeviantArt ProfileSuites: MYiniMeterSkins: Earth