Skip to main content

Portfolio Diversification Report (Bar & Pie Charts)

Learn how to use Navexa’s Performance > Diversification screen to switch between bar and pie charts, apply filters, group holdings, and export your portfolio allocation to Excel.

Updated today

Use the Diversification screen to see how your portfolio is spread across holdings, sectors, brokers and your own custom groups. You can switch between bar and pie charts, change the date, and export the data to Excel.

You can also watch the walkthrough video below for a quick visual guide.


What the Diversification Screen Shows

The Diversification screen gives you:

  • A bar or pie chart showing how your portfolio is allocated

  • An As at date so you can see diversification on a specific day

  • Options to include all positions (including sold holdings) or open positions only

  • A Group by menu so you can change how the chart is broken up (for example by holding or sector)

  • A detailed table under the chart listing each slice with value and weighting

  • An Export option to download the data to Excel


How to Open the Diversification View

  1. Open the portfolio you want to analyse.

  2. In the top menu, select Performance ▸ Diversification.

  3. The Diversification screen will load with your current settings.

Tip: If you’re using filters elsewhere in Navexa, they may already be applied here. Check the filter bar at the top of the page.


Step 1. Set the “As at” Date

At the top left, use the As at date picker.

  • Choose Today to see your current diversification.

  • Pick a past date (for example, 30 June) to see how the portfolio looked on that day.

All market values and weightings on this page use the date you select.


Step 2. Choose Which Positions to Include

Next to the date, you’ll see the positions toggle:

  • All positions

    • Includes current and closed/sold holdings.

    • Use this if you want a full history of everything you’ve ever held in this portfolio.

  • Open positions only

    • Hides closed/sold holdings from the chart and table.

    • Use this if you only want to see where your money is currently invested.


Step 3. Use Filters (Optional)

Click Filter to narrow down what appears in the chart.

Common examples:

  • Show just one holding or ticker

  • Focus on a single exchange, sector or industry

  • Exclude a specific ETF or holding from the picture

Active filters show in the filter bar at the top. Click the x on a filter to remove it and return to your full view.

Remember: Filters do not change your data. They only change what you see.


Step 4. Choose How to Group Diversification

The Group by menu controls how the chart is broken up.

Depending on your account, you may see options like:

  • Holding – each individual investment gets its own slice or bar

  • Sector or Industry – group holdings by classification

  • Exchange – ASX, NASDAQ, NYSE, etc.

  • Broker / Source – group positions by broker feed

  • Custom Groups – any group sets you’ve created (for example, “Core / Satellite”, “Australian vs Global”, “Growth vs Income”)

Select an option and the chart will redraw using that grouping.

Example: Choosing Core and Satellite (a custom group) will show how much of the portfolio you’ve classified as Core and how much as Satellite.

Any holdings not yet assigned to a custom group may appear as their own “ungrouped” category until you allocate them.


Step 5. Switch Between Bar and Pie Charts

On the right side of the controls you’ll see chart type buttons:

  • Bar – shows allocation as horizontal or vertical bars

  • Pie – shows allocation as slices of a pie chart

Click Pie to see a traditional diversification view by percentage.

Click Bar if you prefer to compare values side-by-side.

You can hover over any bar or slice to see its:

  • Name (holding, sector, group, etc.)

  • Value

  • Weighting as a percentage of the portfolio


Step 6. Read the Table Under the Chart

Scroll down to see the detailed table.

For each item (holding, sector, group, etc.) you’ll typically see:

  • Name

  • Value (in your portfolio currency)

  • Weighting (% of the portfolio)

Use this table to:

  • Check exact values and percentages behind the chart

  • Sort by value or weighting to see your biggest exposures

  • Cross-check that holdings are in the correct group

If classifications (e.g. sector/industry) don’t look right, you can update them on the individual holding page and the Diversification view will reflect that change.


Step 7. Export Diversification to Excel

To download the data:

  1. At the top right of the chart area, click Export.

  2. Choose Excel (XLSX).

  3. Navexa will download a spreadsheet with the same figures shown in the table.

You can then:

  • Share it with an adviser or accountant

  • Build your own pivot tables or charts

  • Store a copy for your records at a specific date


Common Questions

Why can’t I see some of my holdings?

Check:

  • The positions toggle (set to All positions if you want closed holdings).

  • Any filters that might be hiding certain holdings or sectors.

  • Your Group by setting – for example, grouping by Sector will combine holdings into broader categories.

What does “ungrouped” mean?
It usually means you’re using a Custom Group and some holdings haven’t been assigned to a group yet. Edit your group settings to classify them.

Can I change classifications like sector or industry?
Yes. Open the holding, go to Settings, and update its classification. Future diversification views will use that classification.


Notes and Disclaimer

The Diversification screen is for analysis and reporting only. It does not change your actual holdings or trades.

Figures are based on the data and prices available in your account at the selected As at date and may differ from broker statements depending on price sources and timing.

This article is general information only and is not personal financial, investment, or tax advice. Always consider your own circumstances and, if needed, consult a licensed financial adviser or qualified tax professional.

Did this answer your question?