On my first sheet, I enjoy columns of different notes that I am recycle near investigational background. This information is man referenced to create a mixture of pie charts, on other sheets, that show percentage of a unbroken.
However, when replacing near foreign facts, the size of the pie chart "slices" do not stay consistant near respect to the %'s of facts it represents. The percentage also posted tend to incorrect, basically not the corresponding size of the pie "slice".
How do I hold on to the size of the "slices" from mismatching when I replace the information next to foreign notes?
Thank you for the oblige and touch free to shoot me message if I can clarify anything else.
Answers: You probably needed to check the addition of worksheet, hit F9 for instruction manual cause worksheet to recalculate or walk to menu, tools, option, arithmetic tab, variety sure is automatic.
If still out of use, brand name sure that your investigational set of notes that replacing the ripened set have equal number of elements as the ancient set, motivation even 1 feeble number moved out at the rear could render the unbroken chart wrong.