no line on my graph

[bkarl]

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

 

[HarryS]

Would a trend line for a four week moving average show the same information.

 

[Jon Peltier]

Tools menu > Options > Chart tab, choose Interpolate for how you want the chart to treat blank cells.