Creating chart from table with multiple series

crevert2

New Member
Joined
Sep 15, 2020
Messages
1
Office Version
  1. 365
Platform
  1. Windows
Hey,

I have a table that has costs of 3 sample products. Each month, the cost is recaclulated for the 3 parts and added to the end of the table. I want to create a chart for each part number showing how the cost has changed each month, but I don't know how to get the chart to choose just 1 product from the table that has all 3 products on it. I know I can manually select it but I would like it to automatically update when I add the new months data. Below is a sample table and chart. Is it even possible to do what I want or do I need to sort these into seperate tables?

1600188966502.png
1600189072367.png


Thanks!
 

Some videos you may like

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

jondavis1987

Active Member
Joined
Dec 31, 2015
Messages
411
Office Version
  1. 2019
Platform
  1. Windows
I would do a pivot chart and include product as a filter
 

Watch MrExcel Video

Forum statistics

Threads
1,119,236
Messages
5,576,898
Members
412,752
Latest member
LUIS SAMANO
Top