Ampler Charts lets you hide a series from the plotted chart while keeping it in the data table, so a figure can be shown in the table without being drawn on the chart.
Quick answer: Right-click the data table and click Hide series — the series is removed from the chart but stays in the table.
How to use it
Right-click the data table to hide a series from the plot.
- Right-click on the data table.
- Click Hide series.
The series is removed from the plotted chart but remains in the data table, so its figures are still shown.
When to use it
Hide a series from the chart but keep it in the table when the number should be available to the reader but shouldn’t be plotted — for example a total or a reference figure that would clutter the chart.
How consultants use it
Separating what’s plotted from what’s tabulated gives fine control over an exhibit. Three habits apply:
- Plot only what helps: a series that would clutter the chart is kept off it
- Keep the figure available: the value still appears in the data table
- A cleaner chart: the visual stays focused while the detail stays on the page
Hiding a series from the plot but keeping it in the table keeps a chart clean without losing the figure.
Tips & best practices
- Use it for totals or reference figures that belong in the table, not the plot.
- Keep the data table’s figures consistent with the chart labels.
- Combine with Add a data table to show the full figures beneath.
Availability
Part of Ampler Charts, included in Ampler for PowerPoint and the Ampler Suite, on Windows desktop PowerPoint.
Frequently asked questions
How do you keep a series in the data table but not on the chart?
Right-click the data table in Ampler Charts and click Hide series. The series leaves the plot but stays in the table.
Can you show a figure in the table without plotting it?
Yes — hide the series from the chart while keeping it in the data table.
Why hide a series from the chart but keep it in the table?
When a value — such as a total or reference figure — should be available to the reader but would clutter the plotted chart.
How do you bring the series back onto the chart?
Unhide it from the data table’s right-click menu.