• 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 charts in Excel 2010

N

nefdcraig

New Member
I've just upgrade to 2010 and some reports that worked fine in 2007 and 2003 have stopped working.


I was using the offset function to create a dynamic data range for charting.


If I open the file in 2007 the charts are there and everything works as intended.


If I open the same file in 2010 the charts are there, but all the data series have disappeared.


I've tried renaming and recreating the series, which either fails, or causes excel to crash.


The closest I have got to a solution was using named ranges with a scope of the sheet only in 2003 & 2007, and workbook in 2010. But this only works for the Y data and not the x data.


I hope that I'm just missing something obvious, but any suggestions would be gratefully received


This is driving me mad, as I need users that operate on both systems to be able to use the report. I'm now dreading opening any other spreadsheets as I fear that I'm going to have the same problem with all my dashboards and KPI reports.
 
Nefdcraig


Firstly, Welcome to the Chandoo.org Forums


You problems sound strange as I haven't seen any going forward issues as you mention.

There were a few going from 2003 to 2007 but not to 2010?


Have you saved the file in 2007 as an Excel *.slsx or *.xlsm file and then tried opening in 2010?


Can you send me a copy of your file?

Select Excel Ninja on the left, my email is at the bottom of the page.
 
Hui,


Thanks. I've been lurking on this forum for a long time, and I love the site as it has some great tutorials on which I've been able to put to good use, so to all that have contributed please keep up the good work.


I hadn't tried saving in different formats, but I've done that now and unfortunately got a range of errors, from crashing to ranges disappearing.


I'll send you a couple of test files, which are much smaller but have the same problem as the larger data files.


Thanks in advance, and I hope that you can shed some light on it.


I am looking into whether I can work around the problem with data tables and some VB script (which looks promising), but I'd prefer not to go down this route as some of my clients always disable VB and macros.
 
You must log in or register to reply here.
Back
Top