2 values on 1 axis

[Leo]

have a small spreadshee with 3 columns - Commodity, Tonnage and Value. think
a bar chart showing the Tonnage and Value for each Commodity would be best
but am having trouble setting it up ... any suggestions / tricks??

 

[Jon Peltier]

Leo -

You could make a line chart, using commodity as the X values (category labels) and
the other columns for Y values. Double click one of the series, and on the Axis tab,
select Secondary.

If you want a column chart, there's more work required to keep one set of columns
from overlapping the other. I have posted instructions here:

http://peltiertech.com/Excel/Charts/ColumnsOnTwoAxes.html

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