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

How do I reference a chart series

D

dnessim

Member
Not sure if the title of this thread is even close to my problem.
I have a chart that updates the last N number of values. It uses the named ranges and the offset function. The way i have this set up works on my PC fine but as soon as I open the file on another computer it fails. My theory is something incorect with my reference to my chart series.

This works fine on my pc:
Here is one of my chart series values
=V2UnbilledDashboard.xlsx!TotalCharges

TotalCharges named range is :
=OFFSET(WeekRange,0,1)

WeekRange named range is:
=OFFSET(DashboardData!$A$3,COUNTA(DashboardData!$B:$B)-3,0,-MIN(numweeks,COUNTA(DashboardData!$B:$B)-2),1)

When I open this up on another pc the same series values reads like this:
=[0]!TotalCharges
so obviously it doesnt work on other PC's ,
What would cause this issue?
Thanks
Dave
 
That chart series value looks correct, assuming V2UnbilledDashboard is the name of the workbook with the chart in it. Any other oddities when open on other computer, such as protected mode, no macros, etc? A bit of a stretch, but I admit I am not seeing jumping out to me as obviously wrong. It should be working for you. :(
 
Thanks, acording to that article it requires a service pack update. I will try to get that installed.
Thanks
Dave
 
Yes, thanks all, upgrading to MS Office SP 3 resolved this issue. I am able to now crawl out of the rat hole I found myself in.
Dave
 
You must log in or register to reply here.
Back
Top