Multiple worksheets with non consecutive dates

[watergirl]

I have 10 worksheets per workbook. Each worksheet has the same parameters of which I would like to trend. However due to the dates in each worksheet differing (and non consecutive), the chart accepts the dates of the first worksheet as the x-axis and plots all subsequent worksheets in sequential order

For exampl

Worksheet 1 Worksheet

date, paramete
Jan 1 44 Jan 29 2
Jan 4 55 Feb 35 8

The chart would use Jan1 and Jan 4 on the x axis and plot worksheet 2 values in the first (Jan 1) and the second (Jan 4) values on the x axis

regards

Watergirl

 

[Jon Peltier]

WG -

Make an XY Scatter chart instead of a Line chart. In a line chart, all
the series use the same category (X) data, but in a Scatter chart, the
series can use their own X values.

- Jon