Area Chart - two related values

[ColinH]

Hi,

I have data similar to the below, and we'll call it Product Group

Item - Unit Cost

Lemons  - £10

Oranges - £8

Apples - £5

Limes - £12

Zebras - £200

I'd like to create an area chart that has the sum of all sold Product Group items as a whole, and in the same chart have another entry for everyone in the Product Group except Zebras. Obviously the second line/area would be smaller than the first. I'm sure it's an obvious answer, but I can't think of it. I tried using Groups, but that can only show The group without Zebras and the group with them, but that's not what I'm looking for.

Thanks - this site's been a great help to me!

[v-yuta-msft]

@ColinH ,

---

I'd like to create an area chart that has the sum of all sold Product Group items as a whole, and in the same chart have another entry for everyone in the Product Group except Zebras. 

---

Could you please explain more about this requirement and post the expected result?

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.