I need an Excel Expert who can also do VBA programming for a very small project
Budget: ₹600 – ₹1,500 INR
I want an Excel application which will input real time number from excel sheet and then draw a real time graph for the values. The real time numbers are some calculations which keep changing every second. These calculations are being done is various sheets of my one spread sheet. I want one excel application which will take an input from these numbers. In the required excel file, I will put for example a cell entry as =filename!U49 and then it should take the changing values from there and keep on drawing a real time graph for it. Obviously, these data need to be stored somewhere. The graph's total duration will be 7 hours. Next day again new values will be there. So, it should start with a fresh set of data and so the values used a day before should be deleted. The chart should be a line chart. There would be about four to five set of data cells for which I want the real time line graph.
This is for stocks so for example, 1 value would be stock price. This should be one single graph and the other three values would be numbers running in millions which also be in form of line graph with separate color for each value. The two graphs should be side by side or embedded in one another (obviously, they can’t be one graph because the scale would make impossible to detect the changes in value as one would in thousands and other three in millions). The two graphs should match in time also. There would be about 10 sets of such data or even more so there would at least 5 to 10 such programs running simultaneously. The application should have the flexibility of setting a time period to pick the values as if I feel that 1 second graph is not showing much detail then I can change it 3 second or 5 second interval. The data will come from own excel sheet only. I would also like to be able to copy and paste the data from original sheet and application sheet to whatsapp etc. I tried do this using a code from youtube videos but the main problem is that whenever I copy some data from my original sheet my developed application stops working and this happens also when I try to copy the data from application sheet.
This is for stocks so for example, 1 value would be stock price. This should be one single graph and the other three values would be numbers running in millions which also be in form of line graph with separate color for each value. The two graphs should be side by side or embedded in one another (obviously, they can’t be one graph because the scale would make impossible to detect the changes in value as one would in thousands and other three in millions). The two graphs should match in time also. There would be about 10 sets of such data or even more so there would at least 5 to 10 such programs running simultaneously. The application should have the flexibility of setting a time period to pick the values as if I feel that 1 second graph is not showing much detail then I can change it 3 second or 5 second interval. The data will come from own excel sheet only. I would also like to be able to copy and paste the data from original sheet and application sheet to whatsapp etc. I tried do this using a code from youtube videos but the main problem is that whenever I copy some data from my original sheet my developed application stops working and this happens also when I try to copy the data from application sheet.