Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
carl
 
Posts: n/a
Default Graphing A Time Series of Multiple Stock Prices

My data looks like so:

Stock TradePrice TradeVolume ExecutionDateTime
EFG 5.2 8 2:40:04 PM
EFG 5.5 8 2:40:02 PM
EFG 5.1 10 2:40:01 PM
EFG 5.3 10 2:40:01 PM
EFG 5.1 10 2:40:00 PM
EFG 5.1 10 2:40:00 PM
ABC 1.5 4 2:31:17 PM
ABC 1.6 4 2:31:16 PM
ABC 1.7 2 2:30:51 PM


I am trying to create one graph with price on the Y and time on the X for
all my stocks (in this example just 2 stocks).

Is it possible (I've tried to use the chart wizard with no success).

Thank you in advance.

  #2   Report Post  
Alex
 
Posts: n/a
Default

Carl

Follow the chart wizard to build a simple line chart.

In <Chart Data Source select the <Series Tab.

In here it will be blank (as you have no data selected) so click <add.

Now you will see places to add X and Y axis.

Click on the X-Axis box and add all you time values i.e. 2:40:04 to 2:30:57.

Now, the 'Series' box will be displaying <series1 in the box. In the top
right box ('Name') type EFG. Then in the box below select the EFG values i.e.
5.2 to 5.1 (6 values).

Now select <add to add another series which will appear <series2. This
time add the the name ABC and in the values box select the three values 1.5
to 1.7.

Now you are done and you can format the chart as you like.

Some notes...

(1) If you wnat to add another stock just right click the chart, select
<Data Source and add the new stock folowing the procedure outlined above
i.e. click to add new data series.

(2) One problem of your chart is that if you add stocks of very different $
values e.g. suppose you added GOOG. which is around $180 (???) then your
scale will have to accomodate all the values and you will not be able to see
all the stock lines easily. You can add another y-axis to the right hand side
to overcome this.

Hope this helps.

Alex



"carl" wrote:

My data looks like so:

Stock TradePrice TradeVolume ExecutionDateTime
EFG 5.2 8 2:40:04 PM
EFG 5.5 8 2:40:02 PM
EFG 5.1 10 2:40:01 PM
EFG 5.3 10 2:40:01 PM
EFG 5.1 10 2:40:00 PM
EFG 5.1 10 2:40:00 PM
ABC 1.5 4 2:31:17 PM
ABC 1.6 4 2:31:16 PM
ABC 1.7 2 2:30:51 PM


I am trying to create one graph with price on the Y and time on the X for
all my stocks (in this example just 2 stocks).

Is it possible (I've tried to use the chart wizard with no success).

Thank you in advance.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I display multiple series in a pie chart? AncientPC Charts and Charting in Excel 3 May 3rd 23 05:09 PM
Creating a High-Low-Close chart with multiple series? The Chad Charts and Charting in Excel 3 June 7th 07 06:32 PM
Creating a High-Low-Close chart with multiple series? The Chad Excel Discussion (Misc queries) 0 May 2nd 05 10:19 PM
prehistoric time series Folke Günther Excel Worksheet Functions 3 April 21st 05 02:18 PM
graphing two series on x axis Ladislav Ligart Charts and Charting in Excel 2 December 6th 04 07:50 PM


All times are GMT +1. The time now is 05:48 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"