Stock chart, need help!

  • Thread starter Thread starter chbus
  • Start date Start date
C

chbus

Hi, I'm trying to plot a regular stock chart and using first sub-type o
stock chart. I'm working with Office XP.

I'm able to plot High-Low-Close Price chart, but I also need to plac
Daily Volume numbers next to the date numbers on my
category X-axis.
For example, X-axis should have dates 10/28, 10/29 ... etc. and
corresponding Volume of stock sold each day right next to it(unde
it).

Does anybody know how can I do that? any advice appreciated
 
Set up your data like this, with the Volume data to the left of the Date:

Volume Date High Low Close
972959 12/1/2003 102.20 98.54 98.61
417753 12/2/2003 97.02 97.62 97.08
175397 12/3/2003 95.15 97.55 96.73
185000 12/4/2003 94.35 97.19 96.70
536654 12/5/2003 97.87 99.31 98.29

Select the last four columns and create your HLC chart. Right click the
chart, choose Source Data from the pop up menu, and click on the Series
tab. Select the first series (High), and where is lists the range for
the category labels, change the existing range, e.g.

=Sheet1!$B$2:$B$6

to include also the previous column, e.g.

=Sheet1!$A$2:$B$6

You can edit the text in the box or select the range with the mouse.
The chart now has two rows of labels, with the Volume listed below the
Date. Because of the widths of these labels, you can't put too many
days of data on the chart. A week or so in an embedded chart, maybe two
or three weeks in a large chart sheet if you change to a small font size.

- Jon
 
Back
Top