0
How to make so that when I take the information from a server using mysql, this information appears in the chart sheet already formatted in excel?
1 answer
0
1º You need to define an area in excel for the data that will be used as source for the chart;
2º You need to create a Module in VBA that connects with the Mysql database, select the data you want in the chart and plot the result of this select in the data area of the reserved chart in excel.
3º Whenever you run the macro that makes select in Mysql, the data will be updated in excel.
Example: you create a chart in excel and define that the chart data area will be from cell A1 up to D1000, then when you populate those cells with the data you will bring from the database, the chart will be updated as well.
Browser other questions tagged excel excel-vba
You are not signed in. Login or sign up in order to post.
But it has to be on the same spreadsheet?
– Renata
Normally yes, you can put it in another tab, if you don’t want it to be in the same tab of the chart.
– Jovani