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

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

jondavis1987

Active Member
Joined
Dec 31, 2015
Messages
401
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,114,071
Messages
5,545,818
Members
410,707
Latest member
SanTrapGamer
Top