![]() |
#1
|
|||
|
|||
![]()
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. |
#2
|
|||
|
|||
![]()
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. |
#3
|
|||
|
|||
![]()
Thank you for your reply. I tried to click on the excel document....but it keeps trying to open as a php document.
|
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
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 |
![]() |
leroytrolley | Excel | 1 | 01-16-2009 04:19 PM |