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

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

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,279
Messages
5,546,943
Members
410,764
Latest member
Dedeke
Top