How do I get the information from a server using mysql when this information appears in the spreadsheet with already formatted chart in excel?
Formatting charts in Excel
0
asked by anonymous 10.04.2018 / 15:03
1 answer
0
You need to define an area in excel for the data that will be used as the source for the chart;
You need to create a module in VBA that connects to the MySQL database, select the data you want on 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 the select in MySQL, the data will be updated in excel.
Example: You create a chart in excel and define that the data area of the chart will be from cell A1 to D1000, then when you populate those cells with the data you are going to bring from the database, the chart will also be updated .
10.04.2018 / 16:37