Hello. I amcreating a chart which shows the number of boards cut on a weekly basis. Data is entered on sheet 1 and the chart is on sheet 2.
Row 3 shows the weekly data entered, Row 8 the combined total of the previous weeks. On the chart on the right hand side ,the blue line, i want it to show this combined total. However i want it to do it without defaulting to 0 for the coming weeks. It should stop at week three (as of this week) and not drop to 0.
thanks
Paul.
Bookmarks