Combined chart data series

[jim may]

I have 2 sheets with Data (and Auto-filter usage) to create a Chart (Filtered)
1 for This Year; 1 for last Year.

Can I on Sheet 3 COMBINE the data from above to show the CONTRAST (in one chart between years)? If so, can someone provide tips on how to do so...

Tks,

Jim

 

[Gerald Higgins]

Jim - this is probably do-able but I'm not clear what you mean.

Can you explain in more detail please ?

 

[Jon Peltier]

You can plot data from different sheets onto one chart. Make the chart using the data from one sheet. copy the data from the other sheet, select the chart, and use Paste Special to add the data as new series.

More details can be found at Charting Data From Different Sheets.