Chart the same cell from multiple worksheets in a scatter graph

[JohnHedge]

Hi List,

Basically, what is wrong with this, please? In Select Data Source "Chart data range" ='Jan99'!$B$3,'Feb99'!$B$3,'Mar99'!$B$3.

TIA

John

[jeffreybrown]

Hi John,

Not sure Excel wants to chart across worksheets, so why not link to one sheet of contiguous cells and chart from there?

[JohnHedge]

Thanks for the quick response, Jeffrey.

I was hoping Excel was smarter than that.