Create your chart, with series in rows, so that years appear on the
horizontal axis. I'd say a line chart is probably best. Double click one
series, and on the Axis tab, select Secondary.

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


"dee" wrote in message
...
Yes, the column headings are dates (years).

--
Thanks!

Dee


"Jon Peltier" wrote:

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