graph to show correlation btwn two data sets of different ranges.

B

broken

I have variables a,b,&c for items 1-5. The range for these variables is
100-1000. There is a fourth varibale (d) that ranges from 1-12. I want
to show in 1 graph that changes in variables a,b,&c are directly
correlated to variable d.

Here's what I am thinking:
1. Create a column graph for variables a,b,&c with the y axis label
listed on the left.
2. Add a line graph of variable d with the y axis label on the right.

Problem:
- I have no idea how to add the line graph over the bar graphs.
- I can't for the life of me figure out how to move the y axis label to
the right side.

Any ideas?
Should I make two graphs and perform the final changes in PowerPoint?
 
M

Mangesh Yadav

While creating the graph, in step 1, go to tab custom type, and select
Line-column on 2 axis chart type

Mangesh
 
L

loganmichael

Great,
But how do I format it so that variables a,b,&c are all bars and
variable d is the only line?
I currently have two bars and two lines.
 
M

Mangesh Yadav

right-click on the individual graph / line, and then specify the required
axis in the tab Axis (primary or secondary)

Mangesh
 
Top