Features of the surface plasmon from macroscopic materials emerge in molecular systems, but differentiating collective excitations from single-particle excitations in molecular systems remains elusive. The rich interactions between single-particle electron-hole and collective electron excitations produce phenomena related to the chemical physics aspects within the atomic array. We study the plasmonic properties of atomic arrays of noble (Au, Ag, and Cu) and transition-metal (Pd, Pt) homonuclear chains using time-dependent density functional theory and their Kohn-Sham transition contributions. The response to the electromagnetic radiation is related to both the geometry-dependent confinement of sp-valence electrons and the energy position of d-electrons in the different atomic species and the hybridization between d and sp electrons. It is possible to tune the position of the plasmon resonance, split it into several peaks, and eventually achieve broadband absorption of radiation. Arrays of mixed noble and transition-metal chains may have strongly attenuated plasmonic behavior. The collective nature of the excitations is ascertained using their Kohn-Sham transition contributions. To manipulate the plasmonic response and achieve the desired properties for broad applications, it is vital to understand the origins of these phenomena in atomic chains and their arrays.