• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Graph Series in a Table

Dinesh

New Member
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.
 
Dinesh

Have a look at http://chandoo.org/forums/topic/getting-chart-range

The code there will setup a report of all your charts and series data
 
Back
Top