3d Surface Chart - How to Add Vertical lines for better presentation

**Steveapa** · 06-08-2015, 09:03 AM

Hi All.

I created a 3d surface chart... See image
SurfaceWithOutLines.JPG
I added verticle lines (circled in red) with a pen. These lines make the chart easier to understand.
SurfaceWithLines.JPG
Is there any option in excel that would add these????
Thanks.
Steve
Harrisburg, PA USA

**Kaper** · 06-09-2015, 08:38 AM

I think there is no easy option to do this with Excel.

Of course you can always play some tricks - see attached rough sample where "excel camera" is used to combine 3D Surface with 3D Bar.
Unfortunately in surface we have standard value axes, while in 3d Bar there are categories axes, so more play is needed to have the same spacing between bars as between ticks on 3d surface plot axes.
(1st just 3d plot, 2nd 3D Bars with transparent series fill except of 1st series and last bars of all other series, 3rd the same plot formatted a bit and used to play with camera snap, 4th is in fact not a plot it is combination of 2 pictures from excel camera tool)

But I think that workload to make it looking acceptable is still quite big (bars filled with custom image, etc.)

**Steveapa** · 06-09-2015, 09:15 AM

Thanks! This gives me something to look at. These charts will be in a file that changes. I hope the manipulating of the charts does not get messed up with different sets of data.

Thanks again.
Steve