Spreadsheets

What do you want to do?

MindManager's spreadsheet feature provides a method for including topic-specific numeric data. It uses a standard interface similar to other spreadsheets you have used, and provides basic spreadsheet functions and the ability to display the data as a chart.

The spreadsheet can be sized and displayed or hidden. The data can be shown in spreadsheet form (a data table) or, in chart form (graphical representation).

Read Hint

 

    See also:

 

Insert a spreadsheet

  1. Select the topic(s). On the Advanced tab, in the Topic Data group, click Spreadsheet.
    An empty spreadsheet will appear on the topic(s).

  1. To enter spreadsheet data you must start the spreadsheet edit mode. Do one of the following:

    Right-click the topic's Spreadsheet icon , then click Edit Spreadsheet. OR Select the topic then double-click on the spreadsheet.

Once the edit mode is started you'll see a toolbar with buttons for the spreadsheet commands, and OK or Cancel options for ending the edit mode. In edit mode you can type in the data, or paste it from another application.

Read Hint

Show or hide the spreadsheet

Remove the spreadsheet from the topic

Top of Page

Format and customize the spreadsheet

Once the data is entered, you can go on to rearrange and format it to suit your needs. The spreadsheet functions are based on standard spreadsheet conventions so they will be familiar to you. Options  

To further customize the spreadsheet, you can set the spreadsheet properties. Right-click on the topic's spreadsheet icon and click Spreadsheet Properties.  Options  

After you've entered and formatted the spreadsheet data you can choose to display only the data, or, if you prefer to show a graphical representation of that data, you can create a chart.

Top of Page

View the spreadsheet as a chart

  1. Optional If you are not already in spreadsheet edit mode do one of the following:

    Right-click the topic's Spreadsheet icon and click Edit Spreadsheet.

    OR

    Select the topic then double-click the spreadsheet.

  1. Click Chart View .

  2. To select the chart's data range enter the range limits, or click and drag to select the data, then press Enter.

  3. You'll see a default chart displayed. Click Chart Properties to customize the chart to your liking. Some options can be set directly using the Chart toolbar buttons, or, right-click the chart ,and then click Properties for the full set of options.

Switch between chart view and spreadsheet view

  1. Optional If you are not already in spreadsheet edit mode do one of the following:

  1. Choose the view to display:

Top of Page