Need help with chart

Copper Contributor

Hey, there I'm very new to this and I do not have any experience with excel in depth. So I need help ASAP!

My question is, I'm a stock trader and I would like to create monthly Profit and loss table where I enter my profit and loss for each day for the whole month, and I'm trying to figure out how can I implement a line chart that can update automatically when I enter my $$ for each day and this would also go for the upcoming month. 

 

1 Reply
Table your data (Insert menu | Table) then create the chart while you're active in the table. The table will grow to include new data entered around the immediate perimeter, thus your chart updates automatically.