Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Zachary
 
Posts: n/a
Default Making a bar and a line graph together

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.

  #2   Report Post  
Jon Peltier
 
Posts: n/a
Default

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


Zachary wrote:

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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 10:48 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"