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

Hi
see
http://peltiertech.com/Excel/Charts/Dynamics.html
http://www.tushar-mehta.com/excel/ne...rts/index.html


--
Regards
Frank Kabel
Frankfurt, Germany


matt wrote:
> 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