2 values on 1 axis

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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??
 
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/
_______
 
Back
Top