Hi,
I am new to this forum. So thanks in advance. I have a question:
I have about 120 graphs in an Excel File. Each graph set is 24 graphs.
Chart 25 is same as Chart 1, Chart 26 is same as Chart 2, but for the data colums. The X-axis is common for all charts.
Is it possible to create a table showing the details of each chart so that I can know that each chart is linked to the correct data range e.g.
Name X-Series Y-Series1 Y-Series2 Y-Series3
Chart 1 $A$5:$A$95 $C$5:$C$95 $D$5:$D$95 $E$5:$E$95
Chart 2 $A$5:$A$95 $N$5:$C$95 $M$5:$D$95 $O$5:$E$95
..
Chart 25 $A$5:$A$95 $C$381:$C$470 $D$381:$D$470 $E$381:$E$470
Chart 26 $A$5:$A$95 $N$381:$C$470 $M$381:$D$470 $O$381:$E$470
Hopefully, there is an answer.
I am new to this forum. So thanks in advance. I have a question:
I have about 120 graphs in an Excel File. Each graph set is 24 graphs.
Chart 25 is same as Chart 1, Chart 26 is same as Chart 2, but for the data colums. The X-axis is common for all charts.
Is it possible to create a table showing the details of each chart so that I can know that each chart is linked to the correct data range e.g.
Name X-Series Y-Series1 Y-Series2 Y-Series3
Chart 1 $A$5:$A$95 $C$5:$C$95 $D$5:$D$95 $E$5:$E$95
Chart 2 $A$5:$A$95 $N$5:$C$95 $M$5:$D$95 $O$5:$E$95
..
Chart 25 $A$5:$A$95 $C$381:$C$470 $D$381:$D$470 $E$381:$E$470
Chart 26 $A$5:$A$95 $N$381:$C$470 $M$381:$D$470 $O$381:$E$470
Hopefully, there is an answer.