I am doing a project for a class and I have to add a chart embedded in a form depicting the total value per item. I'm not sure how to do this.
We were given an inventory with the price, so to find the total value so I made an Inventory Value table where I multiplied the quantity by the price. Now I don't know how to insert a chart onto the form (ACase02step8 is the name of the form). I attached the database below because I think that will help to show what I'm trying to do.
The exact instruction for this step was
"Create an Outlet and Inventory Item Data form. The main part of the form is the Outlet and its address. Embedded on the form in datasheet view the Item ID, Quantity on Hand, Item Description and Price for each outlet. Embedded on a separate tab of the same form provide a graph of the total value per item."
I have everything except the last sentence.
Thanks