Hi all, I have database to monitor sales of different products. I am looking for comparison of different products selected by the user. the user has an option of comparing five products with parameter query (i have 5 different toggle button on the form which opens 5 separate queries in pivot chart view with date on x-axis and sales on y-axis ). But the problem is I want to display all in a single chart. Each product has date and sales
for example
product - A
date - 01/01/09, 02/01/09
sales - 9, 10
product - B
date - 01/01/09, 02/01/09
sales - 11, 12
Is it possible to display them in a single chart date on x-axis and sales of product A and B on y-axis.
Thanks for your time.
saM
for example
product - A
date - 01/01/09, 02/01/09
sales - 9, 10
product - B
date - 01/01/09, 02/01/09
sales - 11, 12
Is it possible to display them in a single chart date on x-axis and sales of product A and B on y-axis.
Thanks for your time.
saM
