💻 Software

Excel - Chart that sums the values in multiple rows for each series

Fresh5 days ago

Mar 15, 202668102 views

Confidence Score0%

Problem

Suppose I have a spread sheet that looks something like this... Now, I'd like to create a column chart that has 3 series, one for each country. Then, I want series for each category, but I want to plot the total, not each individual order total. So, something like this (excuse the horrible artwork)…

Unverified for your environment

Select your OS to check compatibility.

Your OS

OS version

Product version

1 Fix

Canonical Fix

Unverified Fix

New Fix – Awaiting Verification

Fix for: Excel - Chart that sums the values in multiple rows for each series

Low Risk

Pivot tables and pivot charts are perfect for this purpose. They'll let you summarise your data into a table and chart and to easily reorganise both of them.

Awaiting Verification

Be the first to verify this fix

Excel - Chart that sums the values in multiple rows for each series

Problem

1 Fix

Fix for: Excel - Chart that sums the values in multiple rows for each series

Environment