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 answers

Line height not remembered in calc

One or multi?

Wi-fi problem on my ps3

Nvidia shield tv: update to 9.2.4 impossible

Wi-fi connection

A company legally obliged to dump its production to its rivals

I no longer have the "birthday" calendar in thunderbird

Error message during et2861 driver installation

Activation of the esu program for updates on windows 10

Update w10 kb5122878 impossible