How do I make a portfolio pie chart in Google Sheets?

Create a 2-column table with holding names in column A and dollar values in column B. Select both columns, click Insert > Chart, and choose "Pie chart" from the chart type menu. Sheets will calculate the percentages automatically. Total time: about 5 minutes.

Is Google Sheets better than a web tool for portfolio visualization?

Both work. Sheets is better if you want to track history over time, link to live stock prices, or share with others who use spreadsheets. A web tool is faster for one-time "what does my portfolio look like" checks and includes additional metrics out of the box.

Can I link Google Sheets to live stock prices?

Yes, using GOOGLEFINANCE. The formula =GOOGLEFINANCE("VTI","price") returns the current price of VTI. You can multiply by your share count to get a live market value. Some tickers (mutual funds, international stocks) are not supported.

Portfolio Pie Chart in Google Sheets vs a Free Tool

Last updated: April 20266 min readCalculator Tools

You have two options for visualizing your portfolio: build it in Google Sheets (10 minutes, customizable) or use a free web tool (30 seconds, instant). Both work. Here is how to do both and when each makes sense.

The Google Sheets approach

Step 1: Set up the data

In a new Google Sheet, create two columns:

Holding	Value
VTI (US Total Stock Market)	45000
VXUS (International Stock)	15000
BND (US Bonds)	12000
VNQ (REITs)	8000
Cash	5000
Bitcoin ETF (IBIT)	3000

Step 2: Insert a pie chart

Select all the data (both columns including the headers). Click Insert > Chart. In the Chart editor, change "Chart type" to "Pie chart." Done. Sheets calculates percentages automatically and displays them on the chart.

Step 3: Add a total

In a new cell below your data, type:

=SUM(B2:B7)

This shows your total portfolio value.

Step 4 (optional): Add live prices

If you want live prices that update automatically, use GOOGLEFINANCE. Add a "Shares" column and a "Price" column:

Holding	Ticker	Shares	Price	Value
VTI	VTI	200	=GOOGLEFINANCE(B2,"price")	=C2*D2
VXUS	VXUS	250	=GOOGLEFINANCE(B3,"price")	=C3*D3

Now your portfolio updates automatically as prices change. The pie chart updates with it.

Enter your holdings and see your portfolio as a pie chart.

Open Portfolio Visualizer →

The web tool approach

Open the portfolio visualizer. Enter holding names and dollar amounts. The pie chart appears immediately with percentages and a legend. Total time: 30 seconds.

No setup, no formulas, no Google account, no file to save. Just type and view.

Enter your holdings and see your portfolio as a pie chart.

Open Portfolio Visualizer →

When to use each

Use Google Sheets when you want:

Historical tracking. Save snapshots of your portfolio month-over-month to see growth.
Live price updates. GOOGLEFINANCE auto-refreshes prices.
Custom calculations. Add your own metrics (cost basis, returns, dividends).
Sharing with others. Spreadsheets are easy to share with a financial advisor or partner.
Integration with other data. Pull in transactions, calculate returns, build a full investment dashboard.

Use the web tool when you want:

Speed. 30 seconds vs 10 minutes for setup.
Privacy. The tool runs in your browser — no Google account, no data sent to servers.
Visual clarity. Auto-formatted pie chart with legend, percentages, and dollar amounts.
Mobile use. Easier to use on a phone than Google Sheets.
One-off visualization. When you just want to see "what does my portfolio look like right now."

Side-by-side comparison

Feature	Google Sheets	Free web tool
Setup time	5-10 minutes	30 seconds
Live prices	Yes (with GOOGLEFINANCE)	No
Historical tracking	Yes	No
Privacy	Stored in your Google Drive	Browser only — nothing saved
Mobile-friendly	Limited	Yes
Customization	High	Limited
Cost	Free	Free
Sign-up required	Google account	None

Both approaches are free. The choice is between setup investment + flexibility (Sheets) vs instant + simple (web tool).

The hybrid workflow

Many investors use both:

Web tool for quick checks. "Is my allocation drifting?" — use the web tool, takes 30 seconds.
Google Sheets for monthly tracking. Save end-of-month snapshots in a sheet, build a chart of total value over time.
Web tool for sharing. Send a screenshot of the pie chart to a family member instead of a spreadsheet they may not understand.

The two tools complement each other. There is no need to pick just one.

Why pie charts work for portfolios

A pie chart is the most intuitive way to see allocation. Each slice represents a percentage of the whole. Big slices instantly show concentration. Small slices show diversification. There is no math required — your eyes do it for you.

For portfolios with 5-15 holdings, a pie chart is ideal. For portfolios with 50+ individual holdings, group them by category (US stocks, international stocks, bonds, etc) before charting — otherwise the slices become too small to read.

The simplest possible workflow

Open the portfolio visualizer
Type each holding name and dollar value
See the pie chart immediately
Note the percentages
Compare to your target allocation
Decide if any rebalancing is needed

Total time: under 2 minutes. Repeat quarterly. That is the entire portfolio review process for most investors.