Excel 2003 Charting: Chart Data Too Complex

I have written a macro in excel 2007 to log water-level readings. Once logged, it automatically charts the data for each of the 30 wells. However, when the workbook is opened in Excel 2003, the chart does not work complaining that the chart data is too complex to be displayed (works fine in 2007). There is one series per well (each well data is logged on a separate worksheet) and has the following formula (so that it will automatically update the chart): =IF(COUNTA('DW1'!$D:$D)-3>0,OFFSET('DW1'!$D$6,1,0,COUNTA('DW1'!$D:$D)-3), 0) Where DW1 is the worksheet name containing the data for well DW1. Any ideas about what is going on? I am using the if statement so that the chart doesn't throw errors if there is no data for a well. I am thinking that the formulas together exceed the limit of the Series data. Anyway to shorten this or change the formula?
Have you tried it with less wells on 2003 to see if there is a point below which it works?

以上就是Excel 2003 Charting: Chart Data Too Complex的详细内容,更多请关注web前端其它相关文章!

赞(0) 打赏
未经允许不得转载:web前端首页 » excel

评论 抢沙发

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址

前端开发相关广告投放 更专业 更精准