Dollar Volume (Price X Quantity) on a secondary Y Axis

[John Smith]

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
--

 

[John Smith]

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

$ volume
10
50
100

 

[Barb Reinhardt]

Create an XY Chart (or a line chart) and select the series you want on the
secondary axis. Select Axis on the Format Data Series menu and you can
choose the secondary axis there.

 

[John Smith]

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?

 

[Barb Reinhardt]

I see you've posted this in the microsoft.public.excel.charting newsgroup as
well. Please post only once. I'll answer there.