Is it accurate that Excel's 'forecast sheet' function can only work with one series at a time?

[Bert_Withpeterson]

Hi all,

I have data similar to the below. I like Excel's 'forecast sheet' function but it only seems to allow me to select one row at a time, e.g. I can only produce a forecast chart with either Site A's data or Site B's, rather than both? This seems as strange to me as if you were only able to produce a line graph or box plot with one series in Excel, surely this isn't actually the case, am I doing something wrong? Thanks!

Site Name	Month 1	Month 2	Month 3
Site A	10	20	30
Site B	15	17	8

 

[RoryA]

A reminder:

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at:

Excel forecasting only allows for one business site to be selected at once?

I have a table similar to the below in Excel with the names of two business sites and their sales values for a number of months. Excel seems to have a good 'Forecast Sheet' function where I can sel...

stackoverflow.com

There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[Jon Peltier]

Correct, the Forecast Sheet feature only works on one series at a time. It's not too hard to combine the results into a single output.