|
||||||||||||||||||||
|
|||||||||||||||||||||
|
#1
02-18-2005, 10:06 AM
|
|||
|
|||
|
multiple x axis data
Hello,
I want to chart two series of data on the same line chart. I have a field entitled "term" for which I want a line for each term. I have a date field entitled "x" and number field entitled "y". The only difficulty is I have two separate sets of data with differing x (or date) axis. How do I chart such data? Excel will only allow me to use on of the x axis or the other. I would like to chart the data below. TermApp,x,y 061,01/05/2005,1 061,01/05/2005,2 061,01/12/2005,3 061,01/12/2005,4 061,01/12/2005,5 061,01/12/2005,6 061,01/12/2005,7 061,01/12/2005,8 061,01/12/2005,9 061,01/12/2005,10 061,01/12/2005,11 061,01/12/2005,12 061,01/21/5200,13 061,01/26/2005,14 061,01/26/2005,15 061,01/26/2005,16 061,01/26/2005,17 061,01/26/2005,18 061,01/26/2005,19 061,01/26/2005,20 061,01/26/2005,21 061,01/26/2005,22 061,01/26/2005,23 061,01/26/2005,24 061,02/01/2005,25 061,02/02/2005,26 061,02/02/2005,27 061,02/02/2005,28 061,02/02/2005,29 061,02/02/2005,30 061,12/15/2005,31 TermApp,x,y 053,01/05/2005,1 053,01/12/2005,2 053,01/12/2005,3 053,01/19/2005,4 053,01/26/2005,5 053,01/26/2005,6 053,02/02/2005,7 053,02/02/2005,8 Thank you for your time and efforts. Sincerely, Christopher Jon Jursa 
|
|
#2
02-18-2005, 10:06 AM
|
|||
|
|||
|
Re: multiple x axis data
Christopher -
Plot the data as two separate XY Scatter chart series, not as Line series, and they should appear just fine on the single X axis. There's a likely typo in point 13 of the first set, I doubt you want 1/21/5200. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Christopher Jursa wrote: > Hello, > > I want to chart two series of data on the same line chart. I have a field > entitled "term" for which I want a line for each term. I have a date field > entitled "x" and number field entitled "y". The only difficulty is I have > two separate sets of data with differing x (or date) axis. > > How do I chart such data? Excel will only allow me to use on of the x axis > or the other. > > I would like to chart the data below. > > TermApp,x,y > 061,01/05/2005,1 > 061,01/05/2005,2 > 061,01/12/2005,3 > 061,01/12/2005,4 > 061,01/12/2005,5 > 061,01/12/2005,6 > 061,01/12/2005,7 > 061,01/12/2005,8 > 061,01/12/2005,9 > 061,01/12/2005,10 > 061,01/12/2005,11 > 061,01/12/2005,12 > 061,01/21/5200,13 > 061,01/26/2005,14 > 061,01/26/2005,15 > 061,01/26/2005,16 > 061,01/26/2005,17 > 061,01/26/2005,18 > 061,01/26/2005,19 > 061,01/26/2005,20 > 061,01/26/2005,21 > 061,01/26/2005,22 > 061,01/26/2005,23 > 061,01/26/2005,24 > 061,02/01/2005,25 > 061,02/02/2005,26 > 061,02/02/2005,27 > 061,02/02/2005,28 > 061,02/02/2005,29 > 061,02/02/2005,30 > 061,12/15/2005,31 > > TermApp,x,y > 053,01/05/2005,1 > 053,01/12/2005,2 > 053,01/12/2005,3 > 053,01/19/2005,4 > 053,01/26/2005,5 > 053,01/26/2005,6 > 053,02/02/2005,7 > 053,02/02/2005,8 > > Thank you for your time and efforts. > > Sincerely, > > Christopher Jon Jursa > >
|
 |
| Bookmarks |
New topics in Excel Charting
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
