I have a MySQL database that is storing processed financial data from a live feed. I would like to stream this processed data into Excel from the database using a RTD. Does anyone have any samples or ideas to help me get started?
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.