I'm busting my brains here ... all I want to do is graph a line representing the values of a single cell across multiple worksheets. To that effect, the chart data range should look something like
@MrSoftware, you might be able to offer some insight into this conundrum of mine ... if you have the time
='Sheet1:Sheet10'!$D$5
But Excel keeps on rejecting it, no matter how many different ways I've tried to tweak it to make it work. What gives?
@MrSoftware, you might be able to offer some insight into this conundrum of mine ... if you have the time