Charts from a table

[billheath]

I have a database that charts the stocks that I own. Each day, it automatically looks up the data fromthe stock exchange and enters the end of day value in a table. The chart looks like this (Made up data):
Date MSFT ADT ADM TMP
2/9/2013 28.50 10.65 4.54 54.60
2/8/2013 10.61 10.63 4.41 54.44
2/7/2013 27.9 10.61 4.40 54.56
'
'
I would like to make a chart of the individual stock performance whenever I go to the form for the stock. The form contains all of the pertinent data*Origional price, dividend, current value etc.) I have looked at every piece of help info that I can find. In the table each stock symbol is the name of a field. All of the help i can find makes the chart by selecting a field of names and specifying which one. This should be simple, but I am racking my brain to ne avail.

Please, help this newbie! You probably need more info. just ask and I will send it. Thanks, Bill

 

[dhookom]

The chart displays what is in the Row Source. It looks like your row source is a crosstab (unless your table is un-normalized). If your data is truly un-normalized, I would start by creating a union query to normalize it.

Duane
Hook'D on Access
MS Access MVP

 

[billheath]

Sorry this has taken so long. Been very busy!
As far as my understanding goes, the darta is normalized. The problem appears to be that the symbol names are in the column headings and the dates are the row headings. The info or prices are in the rows. When I try to create a chart, Access Asks for a colume name. Ie; MSFT. When I try to run the chart, I don't get the values displayed. I get a straight vertical line with a few dots. Access is doing a count of the data points, not the values.
I would appreciate any help you can give me

 

[dhookom]

Modify the Row Source property of the chart after the wizard is finished. Once the data sheet view of the Row Source meets your expectations, it is easier to modify the formatting.

BTW:

 If Currentdb.TableDefs("Your Table Name").Fields(n).Name = "MSFT" Then
    YourApplication.Normalized = False
   Else
    YourApplication.Normalized = Null [COLOR=#4E9A06][b]'don't know for sure[/b][/color]
 End If

Duane
Hook'D on Access
MS Access MVP