How do I add the time dimension in a XY scatter or bubble plot?

Dear all,

I am trying to plot the combination of "b" and "c" series as a time trend.... Using the option of XY scatter or bubble plot, I assign the x and y values in each point. But I can never get them in time sequence because they end up appearing according to the values. I tried to activate the secondary x axis option, but it is not somehow available. Any ideas please?? Im using Excel 2007. Thanking you in advance...

Time b c
2008 278,08 341,96
2009 271,26 331,43
2010 278,89 343,85
2011 302,17 357,87
2012 305,11 305,98
2013 311,39 307,36
2014 319,71 309,94
2015 329,31 314,49
2016 339,69 315,49
2017 350,56 317,05

Do you mean you want 2 sets of plots in the xyscatter? where Time is plotted on the x axis and b and c on the Y.

It would probably help clarify if you posted workbook with data and rough sketch, using shapes, of what you want.

Dear Andy, thank you for keep going with me....

Ok then....so since I have 3 data series, I try the 3D approach...I guess it is clear by now that I am trying to plot
the combined effect of two different variables of the same time-series...

So, using/applying your work on 3D-Rotation which I found online, I definitely need Time sequence on my x-COORD (B2:B11,
and then my other two variables in y and z-coord(C2:D11).So in the end of the day, when I have L12:14=0, I can see in 2 dimensions one position (the combination of y and z-coord) against time (x-coord). This is why I was thinking of a secondary axis at first..

Trying to play with your 3D-sheet (which is the closest I could find to describe what I have in mind), I cannot plot my data, because of different scaling....If I understand correct, in your sheet you set min=-1 and max=1, I changed that to min=0 and max= ??? (400???), as you can see my values on y/z-coord are going up to that value, and they are already normalized.

and then again, values of x-coord are years varying from 1980-2020, would it be possible in such 3D plot to have different scales of numbers?? because when I tried to change the axis and cage dimensions, everything got really messy....

I hope I made it clearer now......

I have adjusted the scales and values for the 3d plot. Not sure it's useful.

Also there is a bubble chart where the size is the second of the 2 values.

When you say 'combined' to you mean added together,

i.e. 278.0760145 + 341.96

If so simply use a helper column to add the values.

To alter the cage or add extra lines you need to create the xyz values, converts those to 2d values using formula similar to existing formula and then add new series to chart.