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

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

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,118,351
Messages
5,571,677
Members
412,412
Latest member
NWPhotoExplorer
Top