If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Secondary axes issues
I have the following sample data....
COL-1 COL-2 Month Cumulative Revenue (Without help) Jan-09 2.20 Feb-09 5.36 Mar-09 10.28 COL-3 COL-4 Dates Cumulative Revenue (With Help) Mar-25 0.20 Mar-28 1.50 Mar-31 2.50 Apr-2 3.25 Apr-5 4.65 I want to show ONE CHART where the revenue trend with help has been better than the months without help I tried using COL-1, COL-2 in primary axes and col 4 in secondary y axis. I am not able to put COL-3 into secondary horizontal axis. COuld you please help |
#2
|
|||
|
|||
Secondary axes issues
I use excel 2007
"Fuzzy" wrote: I have the following sample data.... COL-1 COL-2 Month Cumulative Revenue (Without help) Jan-09 2.20 Feb-09 5.36 Mar-09 10.28 COL-3 COL-4 Dates Cumulative Revenue (With Help) Mar-25 0.20 Mar-28 1.50 Mar-31 2.50 Apr-2 3.25 Apr-5 4.65 I want to show ONE CHART where the revenue trend with help has been better than the months without help I tried using COL-1, COL-2 in primary axes and col 4 in secondary y axis. I am not able to put COL-3 into secondary horizontal axis. COuld you please help |
#3
|
|||
|
|||
Secondary axes issues
I expect I could have worked with two sets of data using Paste Special but I
put my data into a single table date Without With 1-Jan-09 2.2 #N/A 1-Feb-09 5.36 #N/A 1-Mar-09 10.28 #N/A 25-Mar-10 #N/A 0.2 28-Mar-10 #N/A 1.5 31-Mar-10 #N/A 2.5 2-Apr-10 #N/A 3.25 5-Apr-10 #N/A 4.65 Made an XY chart Put the With data on a secondary y-axis Using ChartTools | Format | Axes | Axes, I add a secondary x-axis I then adjusted the scales of the two x-axes Email me (get address from website), ask for DoubleDate workbook and I will send you a file best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "Fuzzy" wrote in message ... I have the following sample data.... COL-1 COL-2 Month Cumulative Revenue (Without help) Jan-09 2.20 Feb-09 5.36 Mar-09 10.28 COL-3 COL-4 Dates Cumulative Revenue (With Help) Mar-25 0.20 Mar-28 1.50 Mar-31 2.50 Apr-2 3.25 Apr-5 4.65 I want to show ONE CHART where the revenue trend with help has been better than the months without help I tried using COL-1, COL-2 in primary axes and col 4 in secondary y axis. I am not able to put COL-3 into secondary horizontal axis. COuld you please help |
Thread Tools | |
Display Modes | |
|
|