Devam Ediyor

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. 1.2438). 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.

Beceriler: Visual Basic

Daha fazlasını görün: 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, macro dynamic row plot graph, dde chart excel dynamic, in this line, in sent, hours cover, excel special, excel sites, excel &, create a line plot

İşveren Hakkında:
( 1 değerlendirme ) Omaha, United States

Proje NO: #41622

Seçilen:

rajanlengde

will be done as soon as accepted and excrowed for.

5 gün içinde 55$ USD
(25 Değerlendirme)
5.1

4 freelancers are bidding on average $73 for this job

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 Daha fazlası

in 3 gün içinde60$ USD
(1 Değerlendirme)
3.4
kmohan1962

Hello, It'll be done through UDF.

in 2 gün içinde75$ USD
(0 Değerlendirme)
0.0
asghar23

i do the work in the four week

in 35 gün içinde100$ USD
(0 Değerlendirme)
0.0