I need to obtain a graph like below.

I want to insert other series into Y axis. It's possible?

thank you.

Hi,

According to your screenshot, we may use 3-D column charts that use three axes that you can modify (a horizontal axis, a vertical axis, and a depth axis), and they compare data points along the horizontal and the depth axes.

Then, we need to modify your data source like below image:

Reference:

https://support.office.com/en-in/article/Available-chart-types-b22a8bb9-a673-4d7f-b481-aa747c48eb3d

Hope it's helpful.

Regards,

George Zhao
TechNet Community Support

Hi George

thank for your help but it doesn't satisfy my needs.

As you can see into my graph I need to cumulate - on Z axis - multiple values (green, yellow and blue represent three series) and not single values (as you propose).

Have you other proposal?

daniele

Hi Daniele,

I have a question, why do you want to add a cumulate column with multiple values in the three-dimensional coordinate? It can't display normal with cumulates chart, because the former cumulates will cover the cumulates behind.  Maybe you only want to show one cumulate column?

Regards,

George Zhao
TechNet Community Support

Hi George

thank for your time...

I need to cumulate for several reasons. It will display correctly because my series are with ascending values so I'll order them in way that all will be visible... or if not... anyway they'll give a macro view and representatio of data. If user that views the graph want depeen...will see the data table with specifics values.

thank you.

Hi Daniele,

I see now, but it seems that we can't get your goal with build-in chart directly. We may use some macros as workaround. :)

Regards,

George Zhao
TechNet Community Support

A macro could  juxtapose inside same graph the two (or more) multiple series and makes something that is not possibile to do normally using Excel user interface?

Hi,

Yes, there is no build-in chart template that you want. We can only use the Gradient fill to close your request. But, it can't display the multiple series in cumulates chart.

In my view, custom a chart via VBA is also a good workaround. I'm not familiar with VBA, if you have further question

Hope it's helpful.

Regards,

George Zhao
TechNet Community Support