i made a chart from line 1 to 10. on line 10 i put SUM function (sum of income) so that line 1-9 gets add up. i put information on line 1 to 9 (i.e. student's name, GPA, age, income, and etc).
I accidentally put wrong information for students line 3-5 so i have to remove them. how do i remove line 3 to 5 information? even if i do, i've noticed that line 6-10 gets ordered from 1-5, not 6-10, and some numbers get changed (I'm assuming this is because of the SUM function that I've already entered).
can someone please help me?
Hi and welcome to our forum!
It's difficult to picture what you mean without seeing an example file. If you want the spacing of lines 3-5 to remain in the chart then delete the contents of those cells rather than deleting the cells/rows.
I doubt the sum function has any bearing on the order of the data in the chart. Hope that helps, but if you're still stuck, please share your file or a desensitised example file.
Mynda
