Hi All,
I am having a bit of a problem in creating a line chart for two different data sets. I have attached the excel file with the data.
Basically there are two different data sets - for stock ABC and XYZ. The data is for 'Time of Trade' and 'Execution Price'. All I need is a line chart with 'Time of Trade' on horizontal axis and 'Execution Price' on vertical axis (price for ABC and XYZ on two vertical axes).
I will be doing this chart everyday with new data, so I am looking to copy and paste data everyday which will automatically feed the data into chart.
This is a part of the report I am working on and I have to submit a draft in the next 2 days. So quick response is very much appreciated.
Kind regards,
Brijendar (BJ) Singh
p.s - I dont really know much about VBAs and macros. So it would be good if the solution could be as simple as possible.
Bookmarks