I have a bar shart where I have something like the image. Now I want to give some future bars.
as example I want to sum the last tree bars and divide this by the number of products in the three months and mulitiply it by the number of product from the next month to create the bar of the next month.
Well, the attached is using a linear trend instead of the calculation you mentioned, but it shows several different ways of showing forecast data, including bars.
