View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Error when creating a stock chart from data in .CSV file

Those aren't dates in the first column, those are large numbers. Excel is
looking specifically for something it recognizes as date-formatted, or text
labels. It couldn't find it, so it gave you the error. You have two ways to
proceed:

1. Delete the label Dates in the top left cell, then select the entire range
and create the chart. The empty cell overrides Excel's own parsing of the
data.

2. Select the three right columns and create the chart. In step two of the
chart wizard, click on the Series tab, click in the Category (X) Axis Labels
box, and select your pseudo-dates, then click Finish.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Curious" wrote in message
...
Jon,

Here're the beginning part of the data in .CSV:

Date High Price Low Price Closing Price
19910717 171.38 170.85 171.31
19910718 177.27 171.29 177.27
19910719 172.87 172.2 172.87
19910722 172.97 172.19 172.42
19910723 172.66 171.12 171.24
19910724 171.25 170.17 170.18
19910725 170.57 169.84 170.56
19910726 170.71 170.4 170.65
19910729 170.71 170.3 170.66
19910730 171.56 170.67 171.54
19910731 172.78 171.49 172.76
19910801 172.77 172.24 172.24
19910802 173.18 171.69 173.05
19910805 173.06 172.37 172.49
19910806 172.92 171.96 172.91
19910807 173.28 172.93 173.06
19910808 173.49 172.94 173.21
19910809 173.39 173.05 173.32
19910812 173.57 173.01 173.55
19910813 174.54 173.55 174.44

Please let me know if you can create a stock chart for the data.