View Single Post
  #1   Report Post  
John Smith
 
Posts: n/a
Default Secondary Axis Annual Units sold on 1 Y Axis - Dollar Volume on another

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