Excel 97.
I've a rather complicated series of linked workbooks/sheets and graphs show incorrect data values even though the source data series show the correct data 'bracketed', with the correct values such as 300, 400 500, but the chart column (stacked)individual values are incorrect e.g 100,6,55! I've tried recalculation [F9] and from within associated VBA code to no avail.......
Had a similar problem when one chart was linked to data in another workbook and this was cured by moving the chart to the source workbook, but I do not know why!
Is this possible due to to many graphs/data point or just memory. Are there limitations within Excel?![[dazed]](/data/assets/smilies/dazed.gif "[dazed] [dazed]")
Thanks for responses in advance.
I've a rather complicated series of linked workbooks/sheets and graphs show incorrect data values even though the source data series show the correct data 'bracketed', with the correct values such as 300, 400 500, but the chart column (stacked)individual values are incorrect e.g 100,6,55! I've tried recalculation [F9] and from within associated VBA code to no avail.......
Had a similar problem when one chart was linked to data in another workbook and this was cured by moving the chart to the source workbook, but I do not know why!
Is this possible due to to many graphs/data point or just memory. Are there limitations within Excel?
Thanks for responses in advance.