Hello,
I am trying to create a graph in excel that I thought would be straighforward but I am having some trouble doing so.
I have 4 products (Product 1,2,3,4) and different prices and volumes for those products. In the graph I would like to show the X axis as volume and the Y axis as price. Each Product would have 1 dot corresponding to the price and volume in the adjacent cell values next to it and would also have the label of the product on the chart next to the dot.
I tried using the XY scatter graph and it plots the data correctly but I cant add the labels next to it or be able to tell which product is which. The ideal would be to show the product label as well as the price and volume next to it (ie. Product 1, $35, 200).
Any help would be greatly appreciated.
Thank you!
Ardit
Bookmarks