Scatter plot not centered

[kotopoulo]

Hello, I try to create a chart with 12 different sets of data. All of them are a bit up or down from a value of 0.86. How can i center the values? I don’t want the empty white space. I want to bring the values (the points) down and to the center.

Thank you

[Lupp]

The Chart wizard should’t produce that image without additional settings. I need to inspect your actuial chart -as it is defined in the sheet- for further investigation.

[EarnestAl]

Unless there is something special about your chart then doesn’t the following do what you want?

• Right-click chart and select Edit
• Right-click y-axis (tooltip will appear when exactly over it) and select Format axis
• In the dialogue that opens select the Scale tab. For Minimum untick Automatic and enter 0.7, or to suit.

[Pollastre]

Attaching the sheet / chart you’re referring to (or a similar example if it contains sensitive information would be helpful)

[kotopoulo]

The below picture is the result I want to achieve. (excuse the image, made in mspaint)

[Lupp]

1. Don’t post/attach images in such a case but a sheet containing your examples.
2. Neither use “Suggest an Answer” nor a “Comment” if you want to clarify / complete your question, but edit it. (“Pencil Tool”)

[Pollastre]

Like what EarnestAI said, you should be able to:

1. Right click on the Y-Axis of your chart (when you hover over it should say “Y Axis”
2. Select Format Axis
3. Ensure the “Scale” tab is selected, then untick Automatic next to Minimum and Maximum.

This will allow you to specify the range of the Y Axis on your chart. For example, to provide a similar result as the image you provided, you could set the Minimum to 0.7 or 0.6, and the Maximum to 1. If this wasn’t what you meant, or need something clarified, feel free to ask!