Combination Line and Bar Graph

M

M Moore

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?
 
A

Andy Pope

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Combination Chart Types Access 2010 0
Combination bar/stacked charts 1
Combining a 2-D column graph and a 2-D line graph on the same char 3
Totals in the data table but not in the graph / chart 1
Graph Line Width ? 1
Remove Bar Graph Axis Values 0
Bar graph to line graph 1
Combination Stacked Bar and Line Graph 1

Top