calculate if your sales are up or down with a nice chart

[rubin718]

Hello Everyone,

Can you please help me make a trend chart to determine if our sales of units in this time span is trending up or down.

Thank you.

 

[jasonb75]

Try selecting your data as shown (including the headers) then on your Excel ribbon, go to Insert > Recommended Charts > All Charts and choose one that you like from the many that are available,

 

[rubin718]

Try selecting your data as shown (including the headers) then on your Excel ribbon, go to Insert > Recommended Charts > All Charts and choose one that you like from the many that are available,

Thanks, I do see some line charts that take me close to my solution. I am looking for a trend line to show if were growing or decreasing in sales.

 

[jasonb75]

I don't think any of the charts include a trendline by default, you have to add one to it yourself.
Choose a chart, then right click and 'Add Trendline'.