Making a bar and a line graph together

  • Thread starter Thread starter Zachary
  • Start date Start date
Z

Zachary

I am required to make a graph called a climate graph. It has to have a
bar and a line on the same graph. Basically all that I need to do is
get the number on the right side to the left and the numbers on the
left to the right. If anyone could help it would be appreciated.
Thanks.
 
Zach -

Don't use the built-in "column and line on two axes" chart type. Make
your chart using the chart type you want on the left for both series.
Double-click the series you want as another type on the right, and on
the Axis tab, select Secondary. Then select just this series, choose
Chart Type on the Chart menu, and select the other chart type you want.

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