Combination Line and Bar Graph
 

I am using a line graph to chart 2 years worth of monthly data (each year a
separate line). I also want to show the YTD totals for both years as a bar
graph (i.e. if the current month is August, I want to show the Jan - Aug
Year 1 total as one bar graph and the Jan - Aug Year 2 total as another bar
graph).

I have successfully both type of graphs into one graph chart. However, I
want to show the bar graph on the right hand side of the graph. How can I
accomplish this?

Combination Line and Bar Graph
 

Hi,

Try double clicking one of the bar (column) series and on the Axis tab
select secondary axis. Select the other bar series and press F4 to
repeat the operation.

Cheers
Andy

M Moore wrote:
I am using a line graph to chart 2 years worth of monthly data (each year a
separate line). I also want to show the YTD totals for both years as a bar
graph (i.e. if the current month is August, I want to show the Jan - Aug
Year 1 total as one bar graph and the Jan - Aug Year 2 total as another bar
graph).

I have successfully both type of graphs into one graph chart. However, I
want to show the bar graph on the right hand side of the graph. How can I
accomplish this?




--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info