I have 2 columns with values, say A and B which values I want to use as X and Y axes values correspondingly.
The values are the following:
A: 412 684 944 2009 9601
B: 7813,4 10377,6 11138,8 16216 606090
When I do it with help of wizard: Insert->2D chart->Right Mouse Click->Select Data after the data is selected it shows me the following chart that is not unfortunately scaled by X axis:
Is there some way how I can automatically scale the X axis?