View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
RodMTS RodMTS is offline
external usenet poster
 
Posts: 1
Default Why is excel 2007 slow when selecting chart data from the formula

Excel 2007 is very slow when selecting chart data from the formula bar. For
example 8, X-Y scatter graph curves are generated from data base of
approximately 2000 lines long x 2 columns. A convienient way to edit the cell
references for each curve is to simply click onto a curve and the cell
references will appear in the formula bar. With all earlier versions of excel
including 2003, once the curve is clicked the cell reference appears in the
formula bar almost instantaneously. However when the same method is used with
excel 2007, it can take 10-20 seconds before the formular appears.