Combination Line and Bar Graph

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

M Moore - 01 Sep 2006 04:11 GMT

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?

Reply to this Message

Andy Pope - 01 Sep 2006 09:13 GMT

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

> 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
[quoted text clipped - 5 lines]
> want to show the bar graph on the right hand side of the graph. How can I
> accomplish this?

Signature

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

Reply to this Message