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

Dynamic Chart with monthly data using a range of 6 years.

F

Fabio Silva

New Member
Hi, I am Fabio.
I’ve been working on an excel file for a long time. I got a problem trying to make a dynamic chart that comprehends a huge flux of data. My supervisor wants me to make monthly charts using different water chemical/physics parameters. In the chart tab, I need to have only the months from the last 6 years. In addition to that, those charts need to update themselves when a set of months of a new year is added. For instance, if I have a range starting from 2008 to 2014 and I add the data from 2015, the data from 2008 needs to be withdrew of the chart, so that the charts will contain the information of the months in the new range from 2009 until 2015. I don`t know even how to start this. Could anyone enlighten me? [ I am still learning English, so if I was not clear on my explanation, please, let me know]
Thank you!
The sample can be found in he link bellow.

https://onedrive.live.com/redir?res...364&authkey=!AGLHW_lq17WWR8w&ithint=file,xlsx
 
Thank you, Nebu. I will check it out and see what I can do. If I have more questions, I will come back with some questions. Have a good day.
 
Hi Nebu,

How are you doing?

I got stuck when I was trying to create the chart. I adapted my data in order to make it easier to work with the examples I saw on the link you gave me last time. For your information, I decided for using the example 5.

As far as I understood, I had to create “Names”, so I went to Name Manager and I created the following names and formulas:

XRange = OFFSET(northsv!$B$5,0,0,COUNTA(northsv!$B:$B),1)

XValues = OFFSET(northsv!$B$5,MATCH(fabio.xlsx!XRange,0)-1,0,northsv!$F$2,1)

YValues =OFFSET(fabio.xlsx!XValues,0,1)

Well, since I have added those names and formulas, I have been trying to create the chart, but I still don`t get it. I tried to adapt this formula bellow according to my spreadsheet information, but it didn’t work.

=SERIES(,'Basic Range'!XValues,'Basic Range'!YValues,1)

So far, Am I doing right? Do you have another suggestion of how to create the chart?

As you can see, I uploaded the spreadsheet I've been working on.

Thank so much for your support!
 

Attachments

  • fabio.xlsx
    13.4 KB · Views: 1
Hi Narayan!
I really appreciate that you spent your time to help me out. Thank you so much.
I took a look on the excel file you sent to me and what I am looking for is dynamic chart in which I can select the starting point and specify the size of the range to be displayed on the chart. For instance, in the cell F1, I have the "Nov-00" as starting point and in cell F2, the number 4, to specify the size of the range. Could you help me to meet those requirements? I hope you have a great day or night!
 
Hi Narayan,

Thank you so much! I really appreciated your desire to help me out. I hope you have a great week. I will keep working on this file so that I can understand what you have done to set up the chart because I need to apply in different scenarios. If I have a question, I will post it here.
 
You must log in or register to reply here.
Back
Top