How to contruc that will adjust itself x & Y axis automatically and provided cosistent graphs all teh time for other values.

Hi, Chaturvedi, Santosh

Sparklines are not suitable here because they do not provide true numeric X and Y axes. An XY (Scatter) chart with straight lines and markers is the better choice. Unlike a regular Line chart, an XY chart treats both axes as numeric values.

Arrange each graph’s data in two columns:

X value Y value

2,000,000 91.02

7,781,792 57.87

15,563,585 57.87

Select both columns, then choose Insert > Scatter (X, Y) > Scatter with Straight Lines and Markers. Right-click each axis, select Format Axis, and make sure Minimum, Maximum, and Major unit are set to Automatic. Excel will then recalculate the scale whenever the source values change.

It is also recommended that you convert the source range to an Excel Table using Ctrl+T before creating the chart. This allows the chart to include newly added rows automatically.

For a consistent appearance, create and format one chart, then copy it for the other datasets and only change its X and Y ranges through Chart Design > Select Data. If the values vary by several orders of magnitude, consider enabling Logarithmic scale under Format Axis, provided the data contains no zero or negative values.

Thank you for your patience in reading, I hope this information has been helpful to you. 

If the answer is helpful, please click "Yes" 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.