With Data Tables, Excel can generate multiple scenarios very quickly and saves time in entering formula in each column and row of a Table. The menu that pops up will show each column of data in your spreadsheet. Another option is to increase the transparency of the gray box. This will tie the textbox to the data in your sheet. With the pivot table selected, find the Analyze tab and click on Insert Slicer. Re: Place shapes behind data cells (Excel 2007) You can place textboxes within the shape and then, for the text, A1, or wherever your data is. I'm working in a pivot table here and I'll add my first slicer. Read Also: How To Make Excel Sort By Click Column Header? Add Your First Slicer to Your Excel Pivot Table. What we saw in above examples is just with single Column Input.ĭata Tables can also be extended to generate scenarios for values in multiple columns also. Now, Excel will substitute the values remaining and generate the results for other students automatically. A B C D Total Marks 200 100% Data -> What-if Analysis -> Data Table. Lets see with an Example Data Table Creation scenario.Īlso Read: How to Convert Word to PDF? How to Use Excel Data Table? – ExampleĪssume that you want to calculate percentage for marks scored by students.īelow Table has the Marks scored out of 200 Marks, by students in a subject. Choose appropriate cells for Row or Column Input.Įxcel will automatically apply the formula and generate results for other values in Table.įor users who are new to What-If Analysis, the above explanation is not good enough.Click Menu -> Data -> What-If Analysis.Second column header with calculation to be tested.

This will help in understanding how Data tables work. Lets first create a Excel Table that has at least 2 columns. A Data Table generates different scenarios for your formula.

How to add shapes in excel data table