Is it possible to graph two sets of data that use a different scale for the X axis - in other words - i have weekly and monthly numbers I want on the same graph overlaying each other. In my data table the weekly data has a data point in each cell of the column but then I average those for the month so there are empty cells in the monthly data colum - when my data set on the graph sees those empty cells it will graph points where the monthly averages are populated but it won't put in a line connecting the points unless i fill in values in the empty cells. Please help - i'm on a time line here!
part of my data table:
2008 ytd Percent Period Percentage
0.001349528
0.002371776
0.001893581
0.001990616
0.001759595 0.175959529
0.001573928
0.001672374
0.001548423
0.001501894 0.112522103
0.001469378
0.001370152
0.001291681
0.001445846 0.133155792
0.001614661
part of my data table:
2008 ytd Percent Period Percentage
0.001349528
0.002371776
0.001893581
0.001990616
0.001759595 0.175959529
0.001573928
0.001672374
0.001548423
0.001501894 0.112522103
0.001469378
0.001370152
0.001291681
0.001445846 0.133155792
0.001614661