Data series disappears when adding bevel shape effect

[The13th]

Hello,

I was recently upgraded to Windows 10 and Excel 2016. I'm making multiple 2D stacked bar charts and would like to add a bevel shape effect to each data series. My smallest chart has 70 rows of data and I have no problem adding the bevel effect to that chart. My other charts, however, have anywhere from 170-470 rows of data and when I attempt to add a bevel effect to these, the selected data series disappears from the chart.

Before the upgrade, I had Excel 2010 and simply used one of the default chart designs. Now I am merely trying to recreate that style so my new charts will look consistent with my previous charts.

Does anyone have any advice on how to prevent my data series from disappearing when I apply a bevel effect?

 

[Kamolga]

When you click on the + on top right of the graph, you can add your series as you like.

Otherwise, you can open a graph that is exactly as you like, right-click it and save it as template. Now when selecting your data, you can directly apply your template. With my version, I click insert tab, click on 'more graph type' below bar type (option available with any type) and there can select my templates (first in left column)

 

[The13th]

Thank you for your response. Clicking on the + didn't work for me, but I was able to save an older graph as a template and that seems to be working.

 

[Kamolga]

You can build directly as template otherwise for existing, when in design tab, click change chart type and select your template.

Have no idea why excel behaves like this but most important is that the workaround works.

 

[The13th]

The saved template workaround works for all but one of my charts. For the last chart in question, I need to color code each bar and I've been doing so manually (using right click and shape fill). I can start to color code without issue. However, once I attempt to change the color for the last series, that series disappears.

To illustrate, this is what my chart looks like before I begin to color code:

Now I begin to color code. For the purpose of this example, I alternated between green and red for each data series. For each team, I am able to change the colors for all but the last series without issue.

Now I tried to change the color for the final data series for the Mets from default to red. Instead, it disappears. If I hover my mouse over that grayed out series, it just says "Plot Area" rather than display the series value.

It also doesn't matter which order I try to change colors. It's always the last series that I try to change which disappears.

Any advice?

 

[The13th]

Bumping the thread with the hope someone might have some advice for my color coding problem.

 

[Kamolga]

I would try to do copy-paste values of the data in a new file, do the graph and color it. Plenty of chances the problem would disappear

 

[The13th]

Thanks for all of your replies. I really do appreciate it. Unfortunately, I tried to copy and paste the values into a new file and still encountered the same issue when color coding.