• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Duplicate a series within a chart

nagovind

Member
Dear All,
Kindly advise how to Duplicate a series within a chart
I have a chart name Chart 1 with Series1 as one curve
I need to Duplicate Series 1 with the same data range with the name as Series 2 in the same chart 1
Is there is any code that will do the above task

Regards
Narayan Govind
 
nagovind
#1 goto Select Data Source
#2 press [ + ] to get new Serie
Screenshot 2022-01-07 at 20.03.24.png
#3 Copy Series1's Y-values range to Series 2' Y-values range
#4 Copy Series1's Horizontal ... range to Series 2' Horizontal ... range
#5 Press [ OK ]
Screenshot 2022-01-07 at 20.04.05.png
 
vletm
Thank you for your resolution
Kindly advise what version of this excel you are referring to. I'm using office 365 in windows 10 OS where I didn't see this option
 
nagovind
I'm using other version than You as well as other OS.
Look those snapshots.
#1 Move Your mouse over Your chart
#2 Activate with Your mouses 2nd hand button Plot Area
... if You use something else than mouse then ... use it.
#3 Choose Select Data...
Screenshot 2022-01-07 at 20.40.28.png
 
Thank you
I understand that there is no programmatic way to handle this requirement as I have 10 set of such plots and I need to copy it to create another 10 set only by changing the data range
 
nagovind
Your thread is in Ask an Excel Question.
Before #5 reply, You've written only to duplicate one series - above shows something much more (10) - it's so different.
This could do with VBA - especially, if You could upload a sample Excel-file, which has sample of Your chart.
... or ...
Could You create chart with ten series in the beginning? .. why duplicate?
You've written something, You've thought something else ... then You'll get something --- which is something else than You've thought.
 
@vletm
Kindly find attached the file for my case
B and C column has the Series 1, similarly, i have series 2 in E/F, Series 3 in H/I, Series 4 in N/O
Manually i have selected the range for Series 1
Series 1, 2, 3 and 4 (similarly i have 20 more) follow the SAME pattern as like Series 1
So i would like to DUPLICATE Series 1 to as many i want series as 2, 3, 4 etc
Then i will simply DRAG The Range of cells that is pointing to Series 1 to my required range of cells

Above is the idea
Could you please help me
Thank you
 

Attachments

  • duplicate series.xlsx
    14.7 KB · Views: 1
nagovind
Do You have an idea to compare 01-Jan-14 to 08-Jan-22? ... what?
Is there any reason - why there are two times 01-May-14? ... except SERIES 1.
Screenshot 2022-01-08 at 19.47.40.png
 
nagovind
Do You have an idea to compare 01-Jan-14 to 08-Jan-22? ... what?
Is there any reason - why there are two times 01-May-14? ... except SERIES 1.
View attachment 77476
Hi it is only a representation
Not the actual data

Series 1, Series 2 Series 3 Series 4 all are having different data but follow same pattern for different person

Here my request is how to make a chart in a easy way

Create one series 1
Duplicate Series 1 to many that points to same data range and by clicking the plot it will highlight the cells then I will drag those highlighted range to my required series range to 2 3 etc

Regards
 
nagovind
Even a sample data should have ... as realistic as possible.
If Your dates are as those are ... then I would show that with XY-chart.
... Easy way ... Any easy means normally double work!

I tested with one possible way with Your ... data.
I do matter of those dates - handle those like row
as well as those sales - there is one a bit bigger value..
It's possible to get eg lower chart with few steps.
Screenshot 2022-01-08 at 20.06.11.png
Crate one series ... add there other series ... but You should know - what do You would like to get?
 
Kindly advise how to Duplicate a series within a chart
Maybe too simple? Copy the range (CTRL + C) first, than paste it in the chart: select chart, press CTRL + V.

PS: Action can be recorded in a macro. One would need to make it smart+dynamic. But it is a start.
 
Back
Top