A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Two different series



 
 
Thread Tools Display Modes
  #1  
Old September 16th, 2003, 05:51 PM
dvt
external usenet poster
 
Posts: n/a
Default Two different series

gomirage wrote:
hello ,
can anyone help me plotting two different charts (line and column) on
the plot ? i have two dataset with with different X series. When i
plot the colum grph and the line graph the X values are not respected.
For example the first series 1983 to 2000 and the second serie 2000 to
2003.
When i plot i have my column series plot with data at 2000, the
beginning of the second dataset.


Are your data sampled at the same rate? Another way to ask the same
question: do you have one data point per year in both series?

If the answer is yes, you can simply include some blank cells in each
series. At one data point per year, 1983-2003, you have 21 data points. So
if your 1983-2000 data is in A1:A18, make cells A19:22 blank and choose
A1:A22 as the data range for that series. If the data for your 2000-2003
series is in B19:22, make B1:B18 blank and use B1:B22 for that series.

Now plot both of these ranges on the same chart. If my description lacks
depth, detail or clarity, post back and we'll try to help you out.

Dave
dvt at psu dot edu


  #2  
Old September 16th, 2003, 06:14 PM
gomirage
external usenet poster
 
Posts: n/a
Default Two different series

Hey dave, Thank you for the proposition. I will check your method and
get back.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

  #3  
Old September 16th, 2003, 08:50 PM
Jon Peltier
external usenet poster
 
Posts: n/a
Default Two different series

Make an XY Scatter chart instead of a Line chart. The Scatter chart
uses the X values for horizontal placement of points, while the Line
chart merely spreads them out in order, as if there were no numerical value.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

gomirage wrote:
hello ,
can anyone help me plotting two different charts (line and column) on
the plot ? i have two dataset with with different X series. When i
plot the colum grph and the line graph the X values are not respected.
For example the first series 1983 to 2000 and the second serie 2000 to
2003.
When i plot i have my column series plot with data at 2000, the
beginning of the second dataset.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/


  #4  
Old September 17th, 2003, 04:36 AM
Jon Peltier
external usenet poster
 
Posts: n/a
Default Two different series

Not confusing. The problem is that for Line, Column, Bar, and Area type
charts, Excel uses the categories of the first series for all of the
series of that axis group. The way you could try to make it work in
your case is to provide blank cells in one series where only the other
series has data. Like this:

Series 1 Series 2
1983 50
1985 60
1987 71
1989 81
1993 90
1995 101
1997 108
1999 118
2000 124 137
2001 152
2003 168

If you want to make interesting box plots, by the way, I have a page on
my web site that shows how to do nicer ones than just a Hi-Lo-Close type
of chart:

http://www.geocities.com/jonpeltier/...tml#BoxWhisker

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

gomirage wrote:
Ge guys,

I tried hard but the same problem. What i am trying to do is a boxplot
with the first set of data following this procedu

- Highlight the whole table, including figures and series labels, then
click on the Chart Wizard.
- Select a Line Chart.
- At Step 2 plot by Rows, (the default is Columns), then Finish.
- Select each data series in turn and use Format Data Series to remove
the connecting lines.
- Select any of the data series and Format Data Series; select the
Options tab and switch on the checkboxes for High-Low lines and Up-Down
bars.

But when finish the box plot it moves automaticaly to the first data
(1983) or to 2000. In the first case the space is to much and in the
second case the first data of the second series (2000) is hiden.

I hope this no really confusing


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:18 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.