Prevent chart with Smooth Lines from not going less than a minimum value

Rao, Avinash 6 Reputation points
2022-04-19T09:53:29.787+00:00

Hi, I am plotting a smooth line graph for the following coordinates {(1,10),(2,60),(3,50),(4,90),(5,0.5),(6,10),(7,40)}.

The drawn plot appears as though the there were some coordinates for which the y values were negative. Is there a way to avoid the curve from going less than a minimum value say 0.

194200-image.png

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,807 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,509 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,645 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Emily Hua-MSFT 27,526 Reputation points
    2022-04-20T07:27:55.047+00:00

    Hi @Rao, Avinash

    Based on my tests, there is no related option to set the the range of series values for Scatter with Smooth Lines, as it is automatically calculated from the data source.
    We can only set the rang for Y-axis as you do for the chart above.

    The workaround is to use Scatter with Straight Lines Chart, it just connects the data points.

    Besides, if the negative values are not too large, you can try to add auxiliary columns to create a line in place of the X-axis.
    194535-capture112.jpg

    • Such as I add 2 coloums, one includes the values from 0 to 9, this determines the length of the fake x-axis.
    • The another one includes the value "-0.37", which is about the minimum value displayed by Series 2 on your chart above.
    • Then you can insert one Scatter line, remove X-axis and Gridlines, but show the X values for this Scatter line.

    Hope the infromation could be helpful.

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.