Creating a trend??

[RikB]

Ok - I had forecast sales for year 1 and an increase of 10% for year 2.
Now that I have to build the report monthly, it makes sense to;

1/ Increase a few seasonal months were the sales are usually higher
2/ Show a general increase or upward trend so that month 12 doesn't stop at x and then month 1 (yr 2) doesn't suddenly start at x + 10%! So dividing the total by 12 will lead to some odd jumps which are not realistic.


So basically, I know what the monthly forecast figures are using past monthly percentages against the annual total but need to 'tilt the line' upwards showing a general upward trend but
keeping the same annual total!

I suppose one way would be to calculate what 10% of the total is and say it was £12k, then month 12 would be £1k higher than month 1. So reduce Mth 1 and increase Mth 12.
However, what do I do about the intervening months??? How would I calculate them? Besides this isn't a very elegant solution!! : )

Help??

[RikB]

Or more simply

I have a list of figures say 10 10 10 10 10 10 10 10 10 10 TOTAL = 100
I want to retain the TOTAL = 100 but adjust the list to show increments of say 10% (the annual increase).
I might want to end up with just the adjustments so I can subtract and add to the existing figures.

So first few figures will be reduced and the last few increased.

[FlameRetired]

Hi RikB. Welcome to the forum.

You usually get more and faster response if you attach an Excel workbook representative of what you are working with and hope to achieve.

To attach a file to your post: (Please no pics or screenshots ... saves retyping data.),

• be sure to desensitize the data
• click “Go Advanced” (next to Post Quick Reply – bottom right),
• scroll down until you see “Manage Attachments”, click that,
• click “Browse”.
• select your file(s)
• click “Upload”
• click “Close window”
• click “Submit Reply”

The file name will appear at the bottom of your reply.