Can I restyle the result by hand?

Yes. The visual is built from plain Excel objects; recolor, resize and rewrite it as you like.

What happens when I update the cells?

The visual watches the cells it is bound to; change the values and the view redraws itself.

Is my source table modified?

No. The tool only reads your data; the only addition to the sheet is the visual itself.

Can I move to a different template?

Yes; open the gallery again and build a new template on the same data. The old visual stays until you remove it.

Create a Target vs Actual Chart in Excel

In short: Actual against target per category. You pick the template from the gallery and map its fields to your cells; the visual stays bound to the data, updates when it changes, and remains freely editable. The source table is untouched.

What it shows

Compares actual and target side by side for each category, revealing the gap.

When to use it

It earns its place whenever you have to comparing target and actual by product or region in one chart.

Example scenarios

Comparing target and actual by product or region in one chart.
Analysts: compares actual and target side by side for each category, revealing the gap.

What it needs

Columns for the category labels, the actual values and the target values.

How to use it

Select the data range or table you want to visualize.
Open the Charts (Visualizations menu) gallery from the XLMind Plus tab.
Pick the Target vs Actual template and map its fields to your cells.
The visual is inserted bound to your data; it refreshes as the cells change.

What it produces

A live SVG chart shape (auto-refresh and edit).

Effect on your data and undo

Target vs Actual does not change your source data; the result is added as a separate item. It refreshes automatically when the linked cells change. Undo Last rolls the change back in a single step.

How it differs from similar tools

It builds a view Excel does not offer natively, as a data-bound, editable visual in one step; the look refreshes when the data changes.

Good to know

Bindings must match the chart's expected shape; auto-refreshes on source change. Requires the listed data fields (category, actual, target).

Limitations

Requires the listed data fields.

Frequently asked questions

Can I restyle the result by hand?: Yes. The visual is built from plain Excel objects; recolor, resize and rewrite it as you like.
What happens when I update the cells?: The visual watches the cells it is bound to; change the values and the view redraws itself.
Is my source table modified?: No. The tool only reads your data; the only addition to the sheet is the visual itself.
Can I move to a different template?: Yes; open the gallery again and build a new template on the same data. The old visual stays until you remove it.

Works well with

For a similar but different need, use Pictogram Gender
Afterwards, try Create Dashboard
A good companion is KPI Cards

Your Excel data is processed on your own computer and is not shared with AI services. The limited data needed for licensing, sales and support is held on our infrastructure in Türkiye.