multiple series, scatter plot Solved

Question

Hello,

I need to create a scatter plot. I have thirty series to position, each with just one coordinate (an abscissa and an ordinate). Am I required to create thirty data series? Is there a quicker way, such as selecting one column representing the name of each series, another for the abscissas, and a last one for the ordinates?
That would be faster...
Thank you in advance for your solutions!

michel_m · Answer

Hello,

I must be misunderstanding your problem because...

in one column you write your x-coordinates, in another the y-coordinates
you select both and request a scatter plot "with markers only"
--
Michel

giogio · Answer

Hello Michel_m,
more simply, I have thirty points to position, reflecting the data of thirty different objects, and I would like my graph to show the thirty points with the associated names. I would like to know a faster method than the following: series name 1, x-axis, y-axis; series name 2, x-axis, y-axis; ........; series name 30, x-axis, y-axis.
Do you have a solution?
Thank you in advance.

michel_m · Answer

you create a table with 3 columns: series, x-axis, y-axis

you create your scatter plot

then you have an add-in to download
http://www.appspro.com/Utilities/ChartLabeler.htm (in English)

which will attach the labels of your series to the desired locations

you also have
http://boisgontierjacques.free.fr/
in the "graphics" section

--
Michel

ccm81 · Answer

Hello Giogio, hello Michel

or a little macro to put in a module

Public Sub Etiquette(NomFeuille, NumGraph, PlageEtiquette) Dim nbpoints As Long, nupoint As Long With Sheets(NomFeuille).ChartObjects(NumGraph).Chart .ApplyDataLabels ShowCategoryName:=True, HasLeaderLines:=True nbpoints = .SeriesCollection(1).Points.Count For nupoint = 1 To nbpoints .SeriesCollection(1).Points(nupoint).DataLabel.Characters.Text = Range(PlageEtiquette).Cells(nupoint, 1) Next nupoint End With End Sub

have a good continuation

giogio · Answer

You have understood my problem well, however, macros... too few for me! It's a shame there aren't simpler solutions. Thank you nonetheless for your help!

michel_m · Answer

The proposed add-in is a supplemental macro that does not require macros!!  Perhaps if one takes the time to look and try.... :-(  I have wasted my time again --  Michel

giogio · Answer

but no, michel_m, now I know that I have the choice between a macro or an add-in! since I'm at work, the security settings prevent me from downloading anything! thanks again!

Multiple series, scatter plot

7 réponses

"disappearance" from play store

Windows spotlight is not working.

Masked destination layer

Samsung j5 unable to answer

Scam of the suvedene highway

File name too long

No sound with ps3 and hdmi

Wake up from sleep mode in windows 10.

Internet connection problem with my ipad

Free box: remote control broken