• 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

  • debug 4-30-14.xlsm
    527.4 KB · Views: 6
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

  • debug 4-30-14 sm.xlsm
    524.6 KB · Views: 4
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