Time values and time scale

[jlt199]

Hi guys, I have an emergency and I'm really hoping you can be kind enough to help. I've touched on the subject before in other threads, but this is a specific problem different to the others I have asked.

I have a workbook that contains two worksheets of data, more than likely with a different number of filled rows in each sheet.

I want to plot varaibles from each sheet is seperate graphs on a third sheet, with a common x-axis for each chart. The data in each chart is contained in a named range, the contents of which is controlled by two scroll bars, one that denotes the position of the start of the range and the other controls the number of points in a series.

I kinda get everything working if a use a number in the x-axis (Example_dataNumber.xls attached), but if I use time values it all goes to pot! I have to turn off the use of time scale, otherwise all data are posiitoned in the same place on the x-axis. However, if I turn it off the the x-axis are different for the chart containing data from different worksheets. For an illustration please see Example_time.xls attached.

I'm working in Excel 2003 and I'm aware that thing go a little to pot athestically if using 2007, but haven't got around to addressing this yet.

If anyone is able to help me get my x-axis aligned using time values I would be hugely appreciative.

I don't suppose it's too relevent, but I should let you know that this workbook is created using a macro from another workbook. But I'm sure if the problem can be addressed in these workbooks then I can ammend my macro with few problems.