Average prices and chart
E
Every month, I download price data from the system and calculate the average price for that month. I then create a chart to visualize the inflation trend for that month. Can you provide a excel VBA code to automate this process?
- Import data - calculate average - build chart
Next month , import data add it to the same last month.. calculate the average . Build chart
Hello,
Can you provide an example of your data ? We don't need the real datas, but to understand how they are structurated, and what do you want exactly at the end (chart type and content, etc). An example file would be appreciated.