Đang Thực Hiện

A Dynamic Chart in Excel

Description

Spreadsheet to plot data for dynamic chart in excel 2003.

I need a worksheet that will receive data and record it from four separate sites which all send real time numbers using the DDE format. The data that is sent will be numbers that represent monetary rates which are carried 4 places past the decimal point (i.e. [url removed, login to view]). These numbers can be brought into the worksheet using a special paste link which I can do myself. Also I need a cell that will show the time that the data from any of the four sites has changed (i.e. 22:40).

I believe the data should be arranged in columns with the first column being used for time (A2) and the next four columns (B2, C2, D2 and E2) representing the sites with the first row being used as a header. This could be needed to create a dynamic chart.

This is the point where I believe a macro needs to be written so that when a change in the data from any of the four sites occurs the data will be shifted down and a new row inserted automatically so a record of these events is built making it possible to create a dynamic chart.

The chart should be on a separate sheet within the workbook. I would like to see the price range on the left side with all four sites being represented with there own line in a line chart and the time indicator along the bottom like most stock charts if possible. I would also like the chart to cover a specific time frame preferably 24 hours.

Kỹ năng: Visual Basic

Xem thêm: excel dynamic chart, dynamic chart excel, dynamic charts excel, dynamic charting excel, excel chart time frame, excel dynamically graph worksheets, excel macro dynamic chart, dynamic charts excel 2003, dynamic graph excel, excel chart time hours, excel service dynamic chart, excel dynamic header, excel dynamic charts, generate dynamic charts excel, excel 2003 dynamic chart, create dynamic charts excel, dde chart excel dynamic, in sent, hours cover, excel special, excel sites, create line plot, making excel dynamic chart, dynamic excel charting, chart dynamic excel 2003

Về Bên Thuê:
( 1 nhận xét ) Omaha, United States

Mã Dự Án: #41622

Đã trao cho:

rajanlengde

will be done as soon as accepted and excrowed for.

$55 USD trong 5 ngày
(25 Đánh Giá)
5.1

4 freelancer đang chào giá trung bình $73 cho công việc này

jharajnish30

i've lots of experience of developing addins in vb. these addins are for office suit as well as individual office members like word, excel etc. some of addin i developed is meant for vbide itself. hope u will find my d Thêm

$60 USD trong 3 ngày
(1 Đánh Giá)
3.4
kmohan1962

Hello, It'll be done through UDF.

$75 USD trong 2 ngày
(0 Đánh Giá)
0.0
asghar23

i do the work in the four week

$100 USD trong 35 ngày
(0 Đánh Giá)
0.0