En cours

A Dynamic Chart in Excel


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.

Compétences : Visual Basic

en voir plus : 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

Concernant l'employeur :
( 1 commentaire ) Omaha, United States

Nº du projet : #41622

Décerné à:


will be done as soon as accepted and excrowed for.

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 5 jours
(25 Commentaires)

4 freelance font une offre moyenne de $73 pour ce travail


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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(1 Évaluation)

Hello, It'll be done through UDF.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)

i do the work in the four week

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 35 jours
(0 Commentaires)