I need to create one chart that uses 3 different pivot tables. The type of chart is a line chart that shows 3 different series of data: forecast, actuals and the variance (forecast-actuals).

The pivot tables are set up identically, with the PRODUCT ID# as the column (left) and the row/data fields are JAN-DEC (12 months across).

ID |JAN |FEB|MAR|APR|MAY|JUN|JUL|AUG|SEP|OCT|NOV|DEC
1234 |$2 | $4| $6| $3|$ 6|$ 9|$ 1| $2| $ 3| $ 4

The same type of pivot table would be set up the same way for the actuals and the variance.

The chart would plot each of the points for the month for each PRODUCT ID.

Is this possible? (P.S. I'm going to only use the last PRODUCT ID column on the worksheets, which I've already formulated to sum the others).

Thanks.