Chart with different Y axis values

D

Derrick

This may be kind of confusing because I'm not sure if I
can explain this properly.

I'm trying to work out a column chart that compares 2-3
key factors of one product between 2002 and 2003. The
range values for these two factors are significantly
different.

The first 2 columns compare avg selling price for the
product. The range for the selling price is usually less
than $10. The next 2 columns compare volume sold, and the
range is about 1000 units. I try to do a sketch below.
Hope it turns out right.

1000
__
5.3 | |800
__ | |__
| |4.2 | | |
| |__ | | |
| | | | | |
| | | | | |
|02|03| |02|03|
---------------------
avg price volume


I also want the value to be displayed at the top of the
column.

Can anyone help?
Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Chart with different Y axis ranges 1
Line chart - Change the Axis round 1
Searching for last cell address in a row 1
2-y axis line chart 4
3 different scales on the Y-axis 4
Creating a chart with varying data value ranges 1
How to create a chart showing ranges of prices of different produc 9
Database 1

Top