How can I delete shadows in charts?

[gossip_boi]

Hi guys. I want to make the chart like in the png file (it was corrected in Paint). I have a problem with filling the figure: if its visibility is null then I can see the contour behind, if visibility is ok then I can see shadows on the figure (check the Excel file). How can I delete those shadows???

 

[Chihiro]

There really isn't a good way to do it.

You can remove 3d shadow using VBA code (since there is no UI to do this), but there are other effects that's not easy to remove from 3d charts.

Following code will remove 3d shading (run it after you click on the chart object).

Sub Remove3d()
ActiveChart.ChartGroups(1).Has3DShading = False
End Sub

You can go through and test different properties listed in the link to see if you can produce what you are looking for.
https://msdn.microsoft.com/en-us/library/office/dn254151.aspx

Alternately, set it to transparent (visibility null), then you can create another shape to go on top of the chart to hide the bottom line.

Personally, I'd advise against use of 3d charts as it adds nothing of value to data presentation in most cases.

 

[gossip_boi]

Chihiro,

Thx a lot! I'll try them all!