x y scatter plot with "bins"

**MattLangholtz** · 11-17-2009, 09:58 AM

In a scatter plot, I want to replace the x-axis bin numbers with non-numerical labels. It's a scatter plot, but I want to replace the bin number values (column "B") with names (column "A"). Any ideas? Do I have to do this in VBA like http://www.excelforum.com/excel-char...ml#post2198742 ?
Thank you,
ML

**Andy Pope** · 11-17-2009, 10:51 AM

Create a column chart on the extra Bin and dummy values range, P3:Q9.

Copy the range B1:N20
Select chart and Use the Paste Special to add a new series.

Change new series to xy-scatter

**MattLangholtz** · 11-17-2009, 02:37 PM

Thanks Andy, I really appreciate this. Did you create this template, or just modify copy and modify my graph? I'm having trouble recreating your graph without just copying it. Regardless, thanks.
Matt

**Andy Pope** · 11-18-2009, 06:12 AM

I started from scratch using steps outlined.

**gmarsd** · 03-04-2022, 10:01 AM

I tried to follow the pasting instructions but cannot get to work

**AliGW** · 03-04-2022, 10:06 AM

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread