Add new series to existing chart

[LLPlates]

Hello,
I am trying to add a new series to an existing chart.
The chart is a stock chart.
I would like the new series to appear as dots, balls or squares on the existing chart.
When I go to add a new series I get a message 'the data range is too complicated to be displayed, if a new range
is selected it will replace all the series in the series panel'
And, sure enough it does and I have no chart (lucky I have plenty of back-ups)
Have inserted a picture below.
Would be grateful for some ideas if anyone has any
Thank you

 

[GraH]

Hi,
A Stock Char needs data in a certain way and (as far as I know) it cannot be combined with other chart types. If the data you want to add does not follow these "rules", then what you described above happens.

Maybe you can share some data, using XL2BB for convenience, of the chart as is and the new series you want to add.

 

[LLPlates]

Thanks for your reply Grah, I will install the add on and see if the worbook will upload.
Cheers

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Add a new series to an existing chart
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[LLPlates]

Hi,
Sorry, didn't understand what cross posting was. I thought I was not going to get any more replies as file workbook too large to upload.

 

[Peter_SSs]

Sorry, didn't understand what cross posting was.

A reminder ..

If you have posted the question at more places, please provide links to those as well.