Add manual axis limits and static target/goal line on charts

Hi,

It would be extremely valuable to allow manual axis limits on charts (Y-axis and/or X-axis), instead of only dynamic scaling.

For example, if a company has a monthly revenue target of 100K, users should be able to:

• Set a fixed Y-axis range (e.g., 0 → 200K),
• Define visual milestones (e.g., 50K, 100K, 150K),
• Add a target line representing the goal.

This becomes critical when comparing performance across periods or segments.

Today, charts automatically rescale based on the data. While convenient, this makes visual comparison unreliable.
For instance:

• Year A: 20K per month
• Year B: 400K per month

Both graphs appear visually similar because each uses dynamic scaling, which defeats the purpose of comparison.

Fixed scaling ensures that:

• Year-over-year comparisons are meaningful
• Multiple product lines or segments can be evaluated consistently
• Performance gaps are immediately visible
• Targets and progress are easier to communicate to stakeholders

Additionally, the ability to add a static target/goal line would significantly improve usability for sales and management dashboards. This is already a standard feature in many tools (e.g., Pipedrive and others for years).

In short, fixed axis controls + target lines would materially improve analytical accuracy and decision-making.

Thank you for considering this enhancement.