• 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.

Use one line chart with a series of data but show only one data at a time

B

bigjohn

New Member
Hi, how are you all doing?


I am working on some science project. I have 500 series of data that I would like to put on one line chart. And the difficult part is I need to observe how the line behave. I wonder if there is a way to show just one series at a time.


Any idea without breaking my head down. Appreciate asap.
 
Hi bigjohn,


You can use offset() formula to fetch any particular series of data that can be plotted on the graph. What you need to do is to make another similar table with just one row (or) column for the values you want to fetch. Use Drop Down List to select any particular series and connect it with a offset function like this:


offset(reference, row, X,) where x is the value from cell linked to drop down list..

See this sample file:

http://www.4shared.com/file/mgI3HpXN/bigjohn.html


Regards,

FASEEH
 
You must log in or register to reply here.
Back
Top