I have a Workbook, say W.xls
It has 3 Worksheets A, B, C.
Each Worksheet has say, 10 rows, 10 columns of numbers.
I want to:
Create one Chart, very quickly with:
A!A1 to A!J1 as X-axis labels ALL the time.
3 data series, say, line graphs, of Row 7 i.e. A7 to J7 from EACH WorkSheet onto the ONE chart.
I want to be able to quickly modify Row Number to 9, say, A9 to J9 and presto! the Chart shows 3 new lines!
It can be a VBA solution or otherwise.
Now I have to edit the "Source Data" field in the Dialog Box 3 times for each ROW Number change.
Thanking you in anticipation.