Use the Pivot Chart in the Portfolio Area

  • Updated

This article explains how to use the Pivot Chart in the My Portfolio Area.

Access the Pivot Chart

To access the Pivot Chart, click on the Widgets button in the Portfolio header, then select Pivot Chart. The Pivot Chart will open in the bottom half of your window.

Open_the_Pivot_Chart.png

Select the Pivot Chart Row Labels, Column Labels, and Values

There are a couple of ways that you can add and remove fields and values from the Portfolio Pivot Chart. The Pivot Chart interface gives you the ability to customize the chart so you can analyze the Portfolio data that is most important to you.

Drag and Drop Fields

The first method for adding or removing fields or values from the Pivot Chart is to simply drag and drop the fields.

To add a field to the Pivot Chart, select the field from the All Fields section, then drag to the desired location - either Values, Row Labels, or Column Labels - and drop the field. The Pivot Table will automatically update with the added field.

Adding_Fields_to_the_Pivot_Chart.png

To remove a field from the Pivot Chart, select the field from either the Values, Row Labels, or Column Labels section, then drag and drop it into the All Fields section. The Pivot Chart will automatically update with the field removed.

Removing_Fields_from_the_Portfolio_Pivot_Chart.png

Use the Field Menu

The second method to add or remove fields or values from the Pivot Chart is to use the Fields Menu.

To add a field, click on the desired field from the All Fields section, then select where you would like to add the field from the menu. The Pivot Table will automatically update with the added field.

Use_the_Field_Menu_to_Add_to_the_Pivot_Chart.png

To remove a field, click on the desired field from the Values, Row Labels, or Column Labels sections, then select Remove Field. The Pivot Chart will automatically update with the field removed.

Use_the_Field_Menu_to_remove_from_the_Pivot_Chart.png

Using the Field Menu, you can also rearrange the field order, relocate the field to a different area of the Pivot Chart, sort the field values, and apply filters to the field values.

Configure the Pivot Chart Settings

You can use the Pivot Chart settings to configure the appearance and layout of your Pivot Chart.

  1. Click on the settings gear in the All Fields header. The Settings form will open.

    Open_Pivot_Chart_Settings.png
  2. Select a Layout. Options include:

    • Outline

      Outline.png
    • Compact (default)

      Compact.png
    • Tabular

      Tabular.png
  3. Select the Row subtotal position. Options include:

    • First

      Row_Subtotal_First.png
    • Hide

      Row_Subtotal_Hide.png
    • Last

      Row_Subtotal_Last.png
  4. Select the Column subtotal position. Options include:

    • First

      Column_Subtotal_First.png
    • Hide

      Column_Subtotal_Hide.png
    • Last

      Column_Subtotal_Last.png
  5. Select the Row total position. Options include:

    • First

      Row_Total_First.png
    • Hide

      Row_Total_Hide.png
    • Last

      Row_Total_Last.png
  6. Select the Column total position. Options include:

    • First

      Column_Total_First.png
    • Hide

      Column_Total_Hide.png
    • Last

      Column_Total_Last.png
  7. Select whether to Show zero as blank or not. Options include:

    • Yes

    • No

  8. Click OK to apply your changes to the Pivot Chart.

Export the Pivot Chart

OnePlan allows you to export the Portfolio Pivot Chart to many different formats, including:

  • Excel xlsx (pivot table definition)

  • Excel xlsx (all items)

  • Excel xlsx (visible items)

  • Excel xml (all items)

  • Excel xml (visible items)

  • CSV (all items)

  • CSV (visible items)

  • TSV (all items)

  • TSV (visible items)

  • HTML (all items)

  • HTML (visible items)

To export your Pivot Chart:

  1. Click on the Widgets icon in the Portfolio header, then select Pivot Chart > Export, and select the format you would like to export to.

  2. The file will be saved to your Downloads folder.

Export_Portfolio_Pivot_Chart.png

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request