Charting

  • Thread starter Thread starter confused man
  • Start date Start date
C

confused man

Hi all,

I have a fairly large list of data that is traking my stock trades. The data
is listed 2/2/04 2/15/04 3/05/04... all the way from january to
december each month has about 50 transactions. These dates are the dates
sold. I have another column that has the % +/- of each trade. How can I make
a chart that plots each trade and its percentage increase. and then I want
another chart thats monthly +/-
Any suggestions would be greatly appreciated!

Thanks,
Confused Man
 
Hi Confused man

should be simple to plot rates of change - just select the
column with the dates, and the column with the +/- values
and plot as scatter chart with lines - this gives a time
line with points in correct place.

to show values for each month - create a new column with
the formula =MONTH(date_cell)
create a pivot table of this with month as row field, and
the +/- values as data, then you can plot this as a bar
chart - check that the pivot table setting find the
average. you can't do a scatter chart of pivoted data
unless you copy and paste it as values.

i hope this helps
Pete
 
Back
Top