Excel Data Analyst and Charting Specialist

Project Description

I am seeking a skilled Excel Data Analyst and Charting Specialist to convert data from an Excel file with 9 to 10 columns into a browser-rendered chart, similar to the one found at https://altair-viz.github.io/gallery/seattle_weather_interactive.html. The chart should display the data with the X-Axis representing time and the Y-Axis representing the LTP column, incorporating range calculations automatically calculated from the LTP column. The chart should include data points for LTP, BuyPrice, BuyQty, SellPrice, SellQty, LTQ, and Outcome. The specialist should be proficient in Python and may utilize the Altair charting library, but flexibility in the choice of library is acceptable. The budget for this project is $300, and the deadline for completion is July 15, 2024. Additional discussion may be needed to ensure all specified data is accurately reflected in the top and bottom charts, with the desired click and drag functionality as seen on the provided URL.