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

TomServo

TomServo

New Member
Ok, I have searched and googled and tried every example I could find.. but I am still not getting it quite right..

In my project I have data in several sheets, I am querying the attendees of the current event and also of past events. And on my background processing I am pulling out the unique dates and how many people showed on that date.

That part I have working fine (other than the chart adding dates for me that I don't want.. but worked around that issue), but the chart data is dynamic in that the past attendees sheet will grow after each event. I have tried several methods to generate the chart .. but it either does not expand to include new additions or it covers the entire named range and I have good points, then 30 or so 0 value entries.

I am just not sure what I am doing wrong or not doing at all...

Thanks for any input :) And you can ignore any errors that may pop up .. I deleted tabs out of this version to make the file smaller and cut out confusion.
 

Attachments

Hi Tom

You have formula which are referenced by your dynamic formula and these are producing Null results. You need to change your dynamic formula from a CountA formula to a Count formula. So change it to this;

=OFFSET(BackgroundProcess!$AJ$5,0,0,COUNT(BackgroundProcess!$AJ$5:AQ65),1)

Also your DateSeries dynamic formula seems to have some issues. Simplify it to the following;

=OFFSET(CountSeries,0,-1)

Now just reset your charts based on the above and you should be away.

Take care

Smallman
 

Attachments

Thanks Smallman! So, it was a case of me over thinking the problem then.. I knew what could have been the problem.. just not sure how I could fix it.
 
No worries. I think it was more a matter of using the wrong tool for the job, CountA instead of Count.

See you next time.

Smallman
 
I preferred tool is a 12lb sledge hammer... Only odd thing the chart does now is it will show extra points, but if I do a save, it displays properly. That is a very minor issue I am not worried about :) This workbook is already a small beast. But will be pretty cool once I have the latest batch of additions added in.
 
You must log in or register to reply here.
Back
Top