Linking visual properties of charts to cells within tables
Tools and techniques are described for linking visual properties of charts to cells within tables. Methods provided by these tools enable users to select visual properties that are associated with graphical displays of chart data, and to link these visual properties to respective cells within the tables. User interfaces provided by these tools may provide representations of visual properties associated with the graphical displays of chart data, with these representations of the visual properties being responsive to user input to link the cells in the tables to the visual properties. These user interfaces may also include representations of the cells that are associated with the representations of the visual properties.
1. At least one computer-readable storage medium having computer-executable instructions stored thereon which, when executed by a computer, cause the computer to perform a method comprising:
enabling a user to select at least one visual property, associated with a graphical display of data presented within a spreadsheet, for linking to at least one cell within the spreadsheet;
activating a dialog box for linking the visual property to the cell;
presenting, within the dialog box, representations of a plurality of visual properties to the user, and for receiving a selection from the user of at least one of the visual properties for linking to the cell;
linking the visual property to the cell in response to the user selection; and
enabling the user to create at least one formula within the cell, wherein the formula includes only predefined functions supported by a spreadsheet application, and wherein the formula calculates the visual property.
2. The computer-readable storage medium of claim 1 , further comprising instructions for testing for changes to the cell, and for updating the visual property in response to changes to the cell.
3. At least one computer-readable storage medium having computer-executable instructions stored thereon which, when executed by a computer, cause the computer to perform a method comprising:
enabling a user to select at least one visual formatting property, associated with a graphical display of chart data, for linking to at least one cell within a table;
linking the visual property to the cell; and
enabling the user to create at least one formula within the cell, wherein the formula includes only predefined functions supported by a spreadsheet application, and wherein the formula calculates the visual property.
4. The computer-readable storage medium of claim 3 , further comprising instructions for presenting the graphical display of chart data to the user.
5. The computer-readable storage medium of claim 3 , further comprising instructions for activating a dialog box for linking the visual property to the cell.
6. The computer-readable storage medium of claim 3 , further comprising instructions for presenting representations of a plurality of visual properties to the user, and for receiving a selection of at least one of the visual properties for linking to the cell.
7. The computer-readable storage medium of claim 3 , further comprising instructions for activating a tool responsive to user input to select the cell, and further comprising instructions for receiving user input to select the cell.
8. The computer-readable storage medium of claim 3 , further comprising instructions for linking the visual property to the cell by directly entering values into the cell by the user.
9. The computer-readable storage medium of claim 3 , further comprising instructions for dynamically changing the visual property of the chart based on the change in data of the cell that depends on values specified in other cells.
10. A system comprising:
a processor; and
a memory accessible by the processor and having computer-executable instructions stored thereon which, when executed by the processor, cause the processor to perform operations comprising:
enabling a user to select at least one visual property, associated with a graphical display of data presented within a spreadsheet, for linking to at least one cell within the spreadsheet;
activating a dialog box for linking the visual property to the cell;
presenting, within the dialog box, representations of a plurality of visual properties to the user, and for receiving a selection from the user of at least one of the visual properties for linking to the cell;
linking the visual property to the cell in response to the user selection; and
enabling the user to create at least one formula within the cell, wherein the formula includes only predefined functions supported by a spreadsheet application, and wherein the formula calculates the visual property.
11. The system of claim 10 , wherein the operations further comprise generating a graphical display of spreadsheet data.
12. The system of claim 11 wherein the at least one cell includes display units that are included in the generated graphical display of the spreadsheet data.
13. The system of claim 10 , wherein the operations further comprise activating a dialog box enabling linking the visual property to the cell.
14. The system of claim 10 , wherein the operations further comprise generating representations of a plurality of visual properties.
15. The system of claim 10 , wherein the operations further comprise:
receiving a selection of at least one of the visual properties; and
linking the at least one selected visual property to the cell.
16. The system of claim 10 , wherein the operations further comprise:
receiving a selection of a cell; and
activating a tool responsive to receiving the selection of the cell.
17. The system of claim 10 wherein the data comprises a chart.
18. A computer implemented method comprising:
enabling a user to select at least one visual property, associated with a graphical display of data presented within a spreadsheet, for linking to at least one cell within the spreadsheet;
activating a dialog box for linking the visual property to the cell;
presenting, within the dialog box, representations of a plurality of visual properties to the user, and for receiving a selection from the user of at least one of the visual properties for linking to the cell;
linking the visual property to the cell in response to the user selection; and
enabling the user to create at least one formula within the cell, wherein the formula includes only predefined functions supported by a spreadsheet application, and wherein the formula calculates the visual property.
19. The method of claim 18 and further comprising testing for changes to the cell, and for updating the visual property in response to changes to the cell.
20. The method of claim 18 , wherein the operations further comprise generating a graphical display of spreadsheet data.