Applying format to all levels of stacked bar pivot chart

Hi,

I have a stacked bar pivot chart and I want to apply a format such as bevelling to all of the segments of the bar.

It needs to allow for a new series when included in the chart as the data will be changing. I mean I can edit the chart as it stands now and format each series of the chart, but when a series comes in to the data not already appearing in the chart, the formatting will be different.

In my specific example I wish to apply a bevel to all segments of the stacked bars for current and new data.

Thanks

Excel 2010

You can try with Template chart. See here or here.

Hope that help