You can also follow the steps and create a beautiful 3-D cylinder chart in your worksheet. Thus, the labels of the data will appear in the chart.Īfter all the steps, now you will get a new 3-D cylinder chart. Input the number “1” into the corresponding text box”.Now choose the option “Specify interval unit” in the window.And then in the menu, choose the option “Format Axis”.Now right click the “Depth (Series) Axis” in the chart.

When you get the most suitable rotation, close the window.

When you change the rotation, you can also see the change of the chart.

Now in the “Format Chart Area”, adjust the rotation of the X, Y and the perspective of the chart.

In the menu, choose the option “3-D Rotation”.

You may drag according to the actual chart.

Next drag the chart to make it bigger.

Move your cursor to the border of the chart.

Therefore, you need to make further adjustment to make the interface of the chart better. You can see that actually this chart is not so clear. Thus, the 3-D cylinder chart will appear in the worksheet.

In the window of “Insert Chart”, choose the option “3-D Cylinder”.

In the drop-down menu, choose the option “All Chart Types”.

Next click the tab “Insert” in the ribbon.

Select the target area in the worksheet.

Now we will create a 3-D cylinder chart for the data in the worksheet. But you also need further settings to make the effect better. The steps to create a 3-D cylinder chart in Excel are very simple. And here you can also create the cylinder chart with the 3-D effect in worksheet.

Histogram chart excel 2013