M
matt
I am trying to set up a worksheets for our customers to
select one of our products, the number of units they and
then have excell display the total cost for all options,
along with the comparison costs for the competition. I
can do that fine with an ActiveX object (drop-down box
referencing the product data set) and then the (CHOOSE
function) times the units to get the result.
Now, I need to create a four year Total cost of ownership
chart that pulls the raw data into a chart and displays
the competitions data. I can create the chart, but I
don't know how to set a criteria for displaying variable
datasets within a single chart, based on the customer
selection?
Can anyone help?
Thx,
Matt
select one of our products, the number of units they and
then have excell display the total cost for all options,
along with the comparison costs for the competition. I
can do that fine with an ActiveX object (drop-down box
referencing the product data set) and then the (CHOOSE
function) times the units to get the result.
Now, I need to create a four year Total cost of ownership
chart that pulls the raw data into a chart and displays
the competitions data. I can create the chart, but I
don't know how to set a criteria for displaying variable
datasets within a single chart, based on the customer
selection?
Can anyone help?
Thx,
Matt