Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / September 2005

Tip: Looking for answers? Try searching our database.

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

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
broken - 01 Sep 2005 05:48 GMT
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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.