Dear Excel gurus,
I really need some help with Excel xy scatter charts. I need to edit the X Axis values/scale to reflect ONLY values that are charted, instead of a generic range. For example...
I have a scatter chart tied to an Excel worksheet, with a data source that contains 4 Series.
The data source:
Series 1: (X) 3.4 (Y) 10.1
Series 2: (X) 4.5 (Y) 20.5
Series 3: (X) 5.7 (Y) 30.7
Series 4: (X) 7.4 (Y) 40.9
This data source above creates a xy scatter chart that shows a diagonal pattern. For the values displayed on both X & Y Axis (values displayed on actual axis), it is shown as generic ranges (by default):
X axis values are: 0, 1, 2, 3, 4, 5, 6, 7, 8
Y axis values are: 0, 5, 10, 15, 20, 25, 30, 35, 40, 45
My question:
How can I get the axis values to display charted values ONLY, instead of these ranges?
i.e. -
X axis values displayed: 3.4, 4.5, 5.7, 7.4 (instead of: 0, 1, 2, 3, 4, 5, 6, 7, 8)
Y axis values displayed: 10.1, 20.5, 30.7, 40.9 (instead of: 0, 5, 10, 15, 20, 25, 30, 35, 40, 45)
Thank you very very much for the help.
I really need some help with Excel xy scatter charts. I need to edit the X Axis values/scale to reflect ONLY values that are charted, instead of a generic range. For example...
I have a scatter chart tied to an Excel worksheet, with a data source that contains 4 Series.
The data source:
Series 1: (X) 3.4 (Y) 10.1
Series 2: (X) 4.5 (Y) 20.5
Series 3: (X) 5.7 (Y) 30.7
Series 4: (X) 7.4 (Y) 40.9
This data source above creates a xy scatter chart that shows a diagonal pattern. For the values displayed on both X & Y Axis (values displayed on actual axis), it is shown as generic ranges (by default):
X axis values are: 0, 1, 2, 3, 4, 5, 6, 7, 8
Y axis values are: 0, 5, 10, 15, 20, 25, 30, 35, 40, 45
My question:
How can I get the axis values to display charted values ONLY, instead of these ranges?
i.e. -
X axis values displayed: 3.4, 4.5, 5.7, 7.4 (instead of: 0, 1, 2, 3, 4, 5, 6, 7, 8)
Y axis values displayed: 10.1, 20.5, 30.7, 40.9 (instead of: 0, 5, 10, 15, 20, 25, 30, 35, 40, 45)
Thank you very very much for the help.
Last edited: