Having gathered the necessary data and prepared a template, you can create a cost-volume-profit chart by plotting a few key points and looking for trends. The chart actually consists of two lines.

How to Create a Date & Cost Line Chart in Excel. A date-and-cost line chart tracks a commodity's changing price over time. Economists use such diagrams to display broad market trends and predict ...