If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Dynamic Chart Crashing Excel - help plz!
I have 5-6 charts in my spreadsheet. I have made several dynamic... meaning
the update automaticly if I add new data to my sheet. The process has worked fine on several of them. However, on one worsheet in my file, I cannot for the life of me figure out why excel crashes when I name a range in my spreadsheet or if I try to put in a named range in the source data of my chart. Here is what crashes my file. CCB is the chart categories which is the formula =OFFSET(Bills!$B$35,CLX,0,-CLX) CLX is the count of the number of items to display =COUNT($D$36:$D$63) the only problem I see is that when I go into look at how the named ranges are defined I find this under CCB =OFFSET(Bills!$B$35,'CLx',0,-'CLx') ... if I change that to the above formula it crashes... Keep in mind this exact idea works on another identical sheet. HELP! |
#2
|
|||
|
|||
Dynamic Chart Crashing Excel - help plz!
I have no problem with the setup, confirming that it works in other sheets.
I'd suggest that you stop beating your head against the wall, and rebuild the difficult sheet. Sometimes sheets and workbooks can get corrupt. BTW, this formula =OFFSET(Bills!$B$35,CLX,0,-CLX) is equivalent to =OFFSET(Bills!$B$35,1,0,CLX) - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "John" wrote in message ... I have 5-6 charts in my spreadsheet. I have made several dynamic... meaning the update automaticly if I add new data to my sheet. The process has worked fine on several of them. However, on one worsheet in my file, I cannot for the life of me figure out why excel crashes when I name a range in my spreadsheet or if I try to put in a named range in the source data of my chart. Here is what crashes my file. CCB is the chart categories which is the formula =OFFSET(Bills!$B$35,CLX,0,-CLX) CLX is the count of the number of items to display =COUNT($D$36:$D$63) the only problem I see is that when I go into look at how the named ranges are defined I find this under CCB =OFFSET(Bills!$B$35,'CLx',0,-'CLx') ... if I change that to the above formula it crashes... Keep in mind this exact idea works on another identical sheet. HELP! |
#3
|
|||
|
|||
Dynamic Chart Crashing Excel - help plz!
I agree, corrupted. Thanks
"Jon Peltier" wrote: I have no problem with the setup, confirming that it works in other sheets. I'd suggest that you stop beating your head against the wall, and rebuild the difficult sheet. Sometimes sheets and workbooks can get corrupt. BTW, this formula =OFFSET(Bills!$B$35,CLX,0,-CLX) is equivalent to =OFFSET(Bills!$B$35,1,0,CLX) - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "John" wrote in message ... I have 5-6 charts in my spreadsheet. I have made several dynamic... meaning the update automaticly if I add new data to my sheet. The process has worked fine on several of them. However, on one worsheet in my file, I cannot for the life of me figure out why excel crashes when I name a range in my spreadsheet or if I try to put in a named range in the source data of my chart. Here is what crashes my file. CCB is the chart categories which is the formula =OFFSET(Bills!$B$35,CLX,0,-CLX) CLX is the count of the number of items to display =COUNT($D$36:$D$63) the only problem I see is that when I go into look at how the named ranges are defined I find this under CCB =OFFSET(Bills!$B$35,'CLx',0,-'CLx') ... if I change that to the above formula it crashes... Keep in mind this exact idea works on another identical sheet. HELP! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Pasting excel chart into powerpoint | Cowtoon | Charts and Charting | 1 | January 18th, 2006 10:19 PM |
Embedded Excel flips chart | Mark DaChain | General Discussions | 0 | May 10th, 2005 04:30 PM |
how to change range for dynamic chart in excel 2000 with button? | ivan | Charts and Charting | 2 | April 24th, 2005 04:10 AM |
Transparent Excel chart backgrounds | Peggy | Charts and Charting | 1 | September 5th, 2004 04:41 AM |
resizing chart title box Excel 97 | Andy Pope | Charts and Charting | 1 | February 28th, 2004 03:26 AM |