Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-05-2013, 08:24 PM
Alaska1 Alaska1 is offline column clustered bar graph with a line graph as secondary axis Windows 7 64bit column clustered bar graph with a line graph as secondary axis Office 2007
Advanced Beginner
column clustered bar graph with a line graph as secondary axis
 
Join Date: Nov 2011
Posts: 93
Alaska1 is on a distinguished road
Default column clustered bar graph with a line graph as secondary axis

I need to create a clustered column bar graph with a secondary axis as a line graph.

the clustered column graph will have 7 categories and will be by month. The clustered column will each have a score. I need to create a secondary axis which needs to show the correlation of the score. How do I arrange the data?

Cat 1 Cat 2 Cat 3 Cat 4 Cat 5 Cat 6 Cat 7
November
9.26 8.97 9.34 9.05 9.16 9.47 9.34 score
0.4 0.26 0.43 0.69 0.62 0.28 0.2 correlation

Cat 1 Cat 2 Cat 3 Cat 4 Cat 5 Cat 6 Cat 7
December 9
.31 8.65 9.24 9.01 9.20 9.27 9.50 score
0.2 0.13 0.23 0.39 0.61 0.29 0.2 correlation



How do I arrange the data? How can I get the Horizontal axis to be nov and december with the categories in the clustered bar graph with the score and have the correlation as the secondary axis?

Last edited by Alaska1; 01-07-2013 at 06:07 PM.
Reply With Quote
  #2  
Old 06-09-2014, 09:17 AM
lynchbro lynchbro is offline column clustered bar graph with a line graph as secondary axis Windows 8 column clustered bar graph with a line graph as secondary axis Office 2010 64bit
Advanced Beginner
 
Join Date: Jun 2014
Location: New York
Posts: 41
lynchbro is on a distinguished road
Default

I have attached the template.

First you must create a bar graph for the scores. Then right click into the bar graph area and "select data source". You will have to add in Legends separately for the correlations. After that just use the design tab for the chart layouts that you like and then have fun with it. Hope this helps.
Attached Files
File Type: xlsx Example.xlsx (12.3 KB, 8 views)
Reply With Quote
  #3  
Old 06-09-2014, 07:13 PM
Alaska1 Alaska1 is offline column clustered bar graph with a line graph as secondary axis Windows 7 64bit column clustered bar graph with a line graph as secondary axis Office 2007
Advanced Beginner
column clustered bar graph with a line graph as secondary axis
 
Join Date: Nov 2011
Posts: 93
Alaska1 is on a distinguished road
Default

Thank you for your reply. I tried to click on the excel document....but it keeps trying to open as a php document.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
column clustered bar graph with a line graph as secondary axis how to display Timestamp on x-axis in Scatter smooth line graph bugserm Excel 1 01-23-2012 02:28 AM
Line Graph Overlay mgonda Office 0 11-14-2011 05:53 PM
Triple Axis Line Graph sschultz0956 Excel 1 09-28-2010 12:39 PM
how do I add data values in Col A into X axis on bar graph? hazz Excel 1 04-27-2010 01:42 PM
column clustered bar graph with a line graph as secondary axis Target line on a excel graph leroytrolley Excel 1 01-16-2009 04:19 PM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 07:57 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft