Do you have categories as well? Or would an XY chart, with Qty as X and
Price as Y suffice?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"dee" wrote in message
...
Hi,

I'm not sure if this is possible, but I would like to create a combination
chart the has one axis correspond to the other:

For argument's sake, let's say I buy veggies at a particular price and
want
a chart to reflect the price and the amount purchased:

Qty in lbs. 100 300 200
Price .5 1 2

I want the chart to have a marker for each of the Qty values, but the
second
axis displaying the Price values directly opposite the corresponding Qty
value.

Any help would be appreciated!

--
Thanks!

Dee