Pivot Table chart in form

[billheath]

I would like to show a chart of daily values of the stocks I have invested in. I can use a pivot table but it is extremely difficult to use.

A portion of the underlying table looks like this:

Date_Ending BDX CIM EWG
8/19 97.92 2.92 26.64 ..............
8/16 97.35 2.96 26.77................
8/15 97.83 2.99 26.84 .............
...... .................................

I want to be able to pick a symbol from a combo box and have a chart displayed with date as the horizontal axis and value on the vertical. The pivot table works but I have to manually pick a symbol from a field list and then delete that symbol to add the next.

Is there a simple way to automate this as above?

 

[dhookom]

So, does your underlying table have stock names as field names? If so, what happens if you need to add new stocks?

I don't use pivot charts as I prefer standard charts. Whenever I need PIVOT functionality, I link my data to Excel to generate pivots and pivot charts.

Duane
Hook'D on Access
MS Access MVP