Chart Calculation

sparkwoodand21

New Member
Joined
Nov 17, 2005
Messages
12
Hi,

I have a workbook with lots of charts (around about 100).

The structure of the workbook is as follows:

1 "Data" worksheet which contains output from the corporate system via columnar text dumps

1 "Graph" sheet - which contains the data for the graph (uses sumif to extract relevant information from the Data sheet and structures it in graph friendly format/layout). This sheet also contains the 100 embedded graphs in a designated print area - each graph has 6 data ranges.

The problem that has arisen is as follows:

The word "Calculation" displays constantly in the Status Bar at the bottom of the workbook. This is despite having the workbook set for automatic calculation and also pressing F9 to recalculating manually! It seems that Excel does not calculate everything!

I don't consider the content of the workbook to be sufficiently large to be pushing the limits by any means. But not sure what I have done to cause Excel these difficulties.

The worry is whether the data represented in the graph is fully recalculated!

Any help/thoughts appreciated.

Regards of the season,

John
 

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

GlennUK

Well-known Member
Joined
Jul 8, 2002
Messages
11,701
You say:
I don't consider the content of the workbook to be sufficiently large to be pushing the limit ...

Can you tell us how many cells in how many sheets, and how many of those are formulae?
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,167,834
Messages
5,855,905
Members
431,772
Latest member
dannyboi1

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top