Hello,
I am trying to make a data sheet that when a new column is added the formulas from the previous column are carried over to the new one and automatically become relative to that column? Is this possible? I included a screenshot with one of the current formulas opened. Grateful for any ideas!
iMac (27-inch, Late 2012), OS X Mavericks (10.9)
I suggest using the formulas:
B13=COUNTIF(B$2:B$12, "="&$A13)
select B13 and fill down
select B13 thru B16, copy
select C13, paste
now shrink the table so there are only columns A, B and C. when you add a column the formulas should be automatically added.
There is no way to automatically create a chart when you add a column. It is very simple to add a duplicate chart, though.
1) set up the pie chart the way you want.
2) hold the option key, then click and hold on the chart, drag to duplicate
3) click the "Edit Data References" Button
4) drag the data references (the highlighted cells) once column to the right
WestFalcon,
It looks to me as though you are on the right track to have your New Rows and Columns Autofill with formulas.
The key is to build your table so that you make full use of Header Rows, Footer Rows and Header Columns. And, in the Body, consistent formulas. You seem to have 1 Header Row, 1 Header Column and 5 Footer Rows.
Referring to your screen shot, when you click the Add Row Control (lower left corner), a new row will be added after the last body row, Row 27. Rows 28 to 33 will move out of the way of the new Row 38.
Similarly, if you click the Add Columns control, Column D will be created and it will autofill with the same expression that is in Columns B and C.
Wayne has given you good instructions on adding a Chart.
Jerry
Automatically carry over formulas when a new column is created
