/u/GreenVestment - Your post was submitted successfully.

• Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread.
• Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
• Include your Excel version and all other relevant information

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

If the chart is using your first column for the x axis, add headers to your columns and try creating it again. If you already have headers, and a column to the left of your data with 1,2,3,4 etc. Then edit the chart data so that new column with the number sequence is the horizontal category.

How can you have an x/y scatter with only a Y value…

Assign each category a value: say A=1, B=2, C=3. Enjoy your new x-values!

Optionally add some jitter, say =base_value + 0.01*(RAND()-0.5).

/u/MintakaMinthara - Your post was submitted successfully.

• Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread.
• Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
• Include your Excel version and all other relevant information

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

The quickest way to get each fault type as a different color is to chart them as separate series. You could sort your data by fault type, then select the X and Y points for just one fault type and insert the XY scatter chart. Right click the chart and click on select data, and you should be able to add the other fault type points one fault type at a time. After that you need to show the legend. If you named each series with the fault name, the legend should show which color is which. 

Are you able to sketch the chart yourself? if you can make a meaningful sketch, you are probably are able to chart it too. You can see here my idea. I am not sure about your legend, what a label would do there. Furthermore, it sounds as if you want to have each dot in a different colour, and that makes now sense for a scatter chart, does it? Anyhow, here are some ideas.

/u/ESCF1F2F3F4F3F2F1ESC - Your post was submitted successfully.

• Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread.
• Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
• Include your Excel version and all other relevant information

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

Like this?

https://i.redd.it/ksre24t7fwof1.gif

/u/Complete-Name8740 - Your post was submitted successfully.

• Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread.
• Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
• Include your Excel version and all other relevant information

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

It's possible in excel but it may or may not look like this. In the linked chart, there's three clusters of data points around three values (0.5, 1, 2). It's not clear why the distance between 0.5 and 1 is the same as 1 and 2, so the accuracy of that chart is in question.

In any case, that chart indicates that the gray markers around 0.5, for instance, would all have x-values near 0.5 but none (or few) of the would be exactly 0.5, which is why they aren't in a single column aligned at 0.5. It's implied that the black marker is the average of those points around it and the error bars are the statistics associated with the variation in the gray markers.

To do this in excel, you'd have two series: one for the gray markers showing your actual data, and one for the black markers showing the summary statistics based on the gray markers. Again, if your raw data is dates with no timestamp along with it, then your gray markers will be stacked vertically at that point.

Like this?

https://preview.redd.it/ky4ckc6walif1.png?width=754&format=png&auto=webp&s=0cdb478afe27dbfce72096738c01c0786603d03e

/u/yungkark - Your post was submitted successfully.

• Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread.
• Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
• Include your Excel version and all other relevant information

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

this should be possible with libxlsxwriter using a LXW_CHART_SCATTER chart.

Edit, tested with :

lxw_chart* chart = workbook_add_chart(workbook, LXW_CHART_SCATTER);
chart_add_series(chart, "=Sheet1!A1:E1", "=Sheet1!A2:E2");

I recently tried out this tutorial, and it completely helped my skills! With clear, step-by-step instructions and practical examples, it’s like having a personal mentor guiding you every step of the way.

https://www.etsy.com/listing/1754892474/

Hi! Fixed it- but honestly the set up is horribly unclear. Just need to readjust the "color by" setting.

Only thing I could think to do quickly is set x values to zero and hide the horizontal axis. Hopefully then you’ll just be plotting your points vertically. Hope this helps

So, you have like, X = 1, 2, 3, 4; and Y1 = 1, 4, 9, 16; Y2 = 1.9, 4.1, 9.0, 15.9? And you want to create a fit through all 8 points?

In order to do that with a trendline, you'll need to feed them into your chart as a single series. When you set up the chart, you can select your X range, put in a comma, and select the X range again. Repeat as necessary. Then select the Y1 range, comma, Y2 range, etc.

What that will look like as the SERIES function is,

=SERIES("My Data",(Sheet1!$A$1:$A$4,Sheet1!$A$1:$A$4),(Sheet1!$B$1:$B$4,Sheet1!$C$1:$C$4))

Then you can create your trendline through the single series of data.

/u/Ikebear2 - Your post was submitted successfully.

• Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread.
• Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
• Include your Excel version and all other relevant information

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.