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

Peter Turner

New Member
Hi,

I need to create a chart which automatically changes the number of data points each month. The titles and rows for the data set are aleready in place (they are part of a sheet with moe info on it).

What I want to do is sort of like the OFFSET function to determine the number of points to show. However, instead of using COUNTA I want to determine the number of points to show by referring to a value stored in a cell.


I've tried adapting the method from another Chandoo thread, http://chandoo.org/wp/2009/10/15/dynamic-chart-data-series/ , but without success.

I'd be really grateful for any help...

Peter
 

Attachments

  • Chart query.xlsx
    11.6 KB · Views: 6
  • Chart query.xlsx
    11.6 KB · Views: 1
  • Chart query.xlsx
    11.6 KB · Views: 0
Hi Narayan,

I've tried that and it works just the way I need. I will need to make a copy of my data on another sheet and write some code to do the filtering, but that shouldn't be difficult.

Thanks again.

Peter
 
Back
Top