Pivot Chart

[Mike H.]

I wish to create a pivot chart line graph that has two lines, one line being
the 2007 value and one line being the 2008 line. The data is in two tables.
I sort of figured out how to create the pivot table from two sets of data,
but I can't figure out how to get the chart to have two lines. Ideas?

 

[smartgal]

Can you combine the data into a single table, with one column for 2007 values
and one for 2008 values? Then you could chart right from the single pivot .
.. .

 

[Mike H.]

I will try that. I did come up with a way to do it without using pivot
tables at all, but let me give that a try too.