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

R

rubin718

New Member
Joined
Feb 16, 2022
Messages
17
Platform
  1. Windows
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.

1663083177471.png


Thank you.
 

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.
Sort by date Sort by votes
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,
 
Upvote 0
jasonb75 said:
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,
Click to expand...
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.
 
Upvote 0
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'.
 
Upvote 0
Solution
You must log in or register to reply here.

Similar threads

H
  • Question
'How to' question about a Dashboard
Replies
5
Views
249
etaf
etaf
C
  • Question
Linear Trend Line with data on Secondary Axis
Replies
1
Views
726
Caines530
C
C
  • Question
Linear Trend Line with data on Secondary Axis
Replies
0
Views
455
Caines530
C
S
  • Question
YTD Dynamic Trend formula
Replies
1
Views
457
stroffso
S
H
  • Solved
Create specialized Excel mortgage formula for home sellers holding a mortgage
Replies
3
Views
183
Dave Patton
D

Forum statistics

Threads
1,215,378
Messages
6,124,604
Members
449,174
Latest member
ExcelfromGermany

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top