Write some Software

Details Program must animate a bar chart from excel sheet and import and change an image next to the animated chart at certain intervals. Excel sheet has yearly data (this sheet is already made). 1. Show data via animated chart to track trend in data year to year 2. Display new year with each animated transition For example in year 1, the chart will show 2 bars. In year 2, those bars will change to fit the data of year two (It will say "Year 2" for that period. After all periods ( years) have run, the program will fade in a full chart of all years and changes per year for series 1 and series 2 data. Data consists of two rows and a heading row displaying "years" 3. Must Import .gif images from a file and place next to changing chart during animation. The image will remain the same until a certain number of periods have passed on the chart and then change via fade in to a new image as the chart changes. All images will be taken from the same file as jpg. I need the system to recognize and access multiple image files and easily make the swap. For example, the first images might be names [login to view URL], [login to view URL], d55. jpg. The next series might be names [login to view URL], e32.jpg. The system must know to take all the d images for the first sequence run and then the [login to view URL] images after new numbers are generated by the excel sheet. This can be done in such a way that I must select specific gifs. ( from a dropdown) For example add all "A" gifs then select add all "E" gifs, etc. The gifs are auto-generated already and they have a number after the title, like above [login to view URL], d55. The numbers may change, but the succession will not and the period in which they appear will not change. Therefore it may be possible to create a command in which the lowest number is first and the next successive number follows, whatever it is. for example, first series of pictures are [login to view URL], [login to view URL], d67.jpg. The next series is e21, e35,e47-- they will always be imported successively.