It's better not to rely on the limited choices Excel provides. Make a Line chart
with both series. Double click on the dollar volume series, and on the Axis tab,
select Secondary.

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

John Mansfield wrote:

John,

I believe you want a combination chart with a primary and secondary Y-axis.
In step number one of the chart wizard, go to the Custom Types tab and scroll
down the dialog box until you see the combination chart choices. They a

Line-Column on Two Axis
Lines on Two Axis

----
Regards,
John Mansfield
http://www.pdbook.com


"John Smith" wrote:


In the chart below, the 10 50 and 100 values and $ volume should be on the
right.
$ volume
10
50
100
--

--


----------------------------------------------------
This mailbox protected from junk email by MailFrontier Desktop
from MailFrontier, Inc. http://info.mailfrontier.com

"John Smith" wrote in message
news:lrXxd.234405$V41.22788@attbi_s52...

I would like to develop an Excel Chart with the following data. I have a
chart for 1. and 2. below.:

1. Total Units Sold (Values) (y-axis)

2. A series of years X Axis

But I would like to show corresponding Dollar Volume (Price X Quantity) on

a

secondary Y Axis. Example below:



Units
Dollar Volume @ $10.00 per unit

10
100

5
50

1______________________________________________ 10

Years 2000 2001 2002 2003
--


----------------------------------------------------
This mailbox protected from junk email by MailFrontier Desktop
from MailFrontier, Inc. http://info.mailfrontier.com