close

Is there a way to keep the format that you created on the pivot chart
whenever you refresh the data? This is a great tool for dynamic reporting but
whenever I refresh the chart I lose all the formating.

Hi,

This is a know problem.

Changing a PivotChart removes series formatting in Excel
support.microsoft.com/default...;EN-US;Q215904

Cheers
Andy

Quan wrote:
gt; Is there a way to keep the format that you created on the pivot chart
gt; whenever you refresh the data? This is a great tool for dynamic reporting but
gt; whenever I refresh the chart I lose all the formating.

--

Andy Pope, Microsoft MVP - Excel
www.andypope.info

全站熱搜
創作者介紹
創作者 software 的頭像
software

software

software 發表在 痞客邦 留言(0) 人氣()