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?
Mangesh Yadav - 01 Sep 2005 06:35 GMT
While creating the graph, in step 1, go to tab custom type, and select
Line-column on 2 axis chart type
Mangesh
> 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
[quoted text clipped - 13 lines]
> Any ideas?
> Should I make two graphs and perform the final changes in PowerPoint?
loganmichael@gmail.com - 01 Sep 2005 07:16 GMT
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.
loganmichael@gmail.com - 01 Sep 2005 07:25 GMT
got it! Thanks for your help!
Mangesh Yadav - 01 Sep 2005 07:44 GMT
glad to hear... :)
Mangesh
> got it! Thanks for your help!
Mangesh Yadav - 01 Sep 2005 07:38 GMT
right-click on the individual graph / line, and then specify the required
axis in the tab Axis (primary or secondary)
Mangesh
> 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.