Thanks - I tried the "Line-Column on Two Axis" and it worked.

But the color scheme is ugly. I would like to simply get rid of the legend,
which is easy, and change the bars to different colors, insead of one color.
Can this be done?

--


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

"John Mansfield" wrote in message
...
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