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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|