What it shows
Shows actual values and forecasts the future with a widening confidence band, visualising uncertainty.
When to use it
It tends to help in cases like showing past sales and presenting a forecast range for the coming months. It is aimed mainly at analysts, managers, report authors.
Example scenarios
- Showing past sales and presenting a forecast range for the coming months.
- Analysts: shows actual values and forecasts the future with a widening confidence band, visualising uncertainty.
What it needs
One column with the dates and one with the actual values. You can optionally add the forecast values, the lower-bound values and the upper-bound values.
How to use it
- Pick chart type
- Bind data
- Adjust settings and design
- Insert
What it produces
A live SVG chart shape (auto-refresh and edit).
Effect on your data and undo
Forecast Cone does not change your source data; the result is added as a separate item. It refreshes automatically when the linked cells change. You can reverse it at any time with Undo Last.
How it differs from similar tools
Unlike a static picture you paste in by hand, it stays bound to your data and redraws itself whenever the source cells change.
Good to know
Bindings must match the chart's expected shape; auto-refreshes on source change. Honest empty / dash state. Invalid data shows a localized validation message (no wrong chart).
Limitations
Requires the listed data fields.
Frequently asked questions
- Does Forecast Cone change my source data?
- No. Forecast Cone leaves your source data untouched and adds the result as a separate item.
- Does it work offline?
- Yes. Forecast Cone runs without an internet connection; going online is only needed for licensing, payment and updates.
- Can I undo what it does?
- Yes. Undo Last on the ribbon reverses the last action in a single step.
Your data is processed on your own computer. Your Excel contents are never shared with AI services.