copy chart formatting and chart templates in Excel 2007
in [Charts]
|
Prev: extra info is showing up in my secondary x axis, I can't get rid o
Next: Chart formatting problems (multiple)
From: Astelix on 1 Mar 2010 13:22 In older Versions of Excel it was possible to transfer the formatting from one chart to another with copy/paste special formats. This doesn't work in excel 2007. Excel 2007 has the option of saving chart templates to multiply user defined formats. But this templates don't save many formatting elements (colors, data label option etc.). This is extremly annoying. Where can I find a documentation that lists all the Elements that are saved in a cltx template? Is there any possibility to come close to the old behavior? Is there anything changed in Excel 2010? TZS
From: Jon Peltier on 2 Mar 2010 12:35 Copy - Paste Special Format does in fact work with Excel 2007. What are the steps you are trying to follow? - Jon ------- Jon Peltier Peltier Technical Services, Inc. 774-275-0064 http://peltiertech.com/ On 3/1/2010 1:22 PM, Astelix wrote: > In older Versions of Excel it was possible to transfer the formatting > from one chart to another with copy/paste special formats. This doesn't > work in excel 2007. Excel 2007 has the option of saving chart templates > to multiply user defined formats. But this templates don't save many > formatting elements (colors, data label option etc.). This is extremly > annoying. > > Where can I find a documentation that lists all the Elements that are > saved in a cltx template? Is there any possibility to come close to the > old behavior? Is there anything changed in Excel 2010? > > TZS > >
From: Astelix on 2 Mar 2010 15:30 In my (German) Version (SP2 ) on Win 7/64 Paste Special (Inhalte einf�gen) doesn't. work. My boss also has Win 7/64 + Excel 2007 and it doesn't work either. The Item on the Ribbon is not grayed out, but it simply does nothing with charts. After your posting I tried it on my Vista/32 bit Notebook and my Win 7/32 Netbook. It works on both. So it seems to be a Win/x64 issue. Thank you for your help. "Jon Peltier" <jonNO(a)SPAMpeltiertech.com> schrieb im Newsbeitrag news:u0nvQ7iuKHA.5936(a)TK2MSFTNGP04.phx.gbl... > Copy - Paste Special Format does in fact work with Excel 2007. What are > the steps you are trying to follow? > > - Jon > ------- > Jon Peltier > Peltier Technical Services, Inc. > 774-275-0064 > http://peltiertech.com/ > > > On 3/1/2010 1:22 PM, Astelix wrote: >> In older Versions of Excel it was possible to transfer the formatting >> from one chart to another with copy/paste special formats. This doesn't >> work in excel 2007. Excel 2007 has the option of saving chart templates >> to multiply user defined formats. But this templates don't save many >> formatting elements (colors, data label option etc.). This is extremly >> annoying. >> >> Where can I find a documentation that lists all the Elements that are >> saved in a cltx template? Is there any possibility to come close to the >> old behavior? Is there anything changed in Excel 2010? >> >> TZS >> >>
From: Astelix on 3 Mar 2010 03:52 It is no 64 bit problem. Copy/Paste Special works with standard charts, but it doesn't work with pivot charts (which I tried to use). User defined templates work partially with pivot charts. "Astelix" <tzs(a)live.de> schrieb im Newsbeitrag news:67D9347C-5E2E-4F4B-A48F-0BF822C873C6(a)microsoft.com... > In my (German) Version (SP2 ) on Win 7/64 Paste Special (Inhalte > einf�gen) doesn't. work. My boss also has Win 7/64 + Excel 2007 and it > doesn't work either. The Item on the Ribbon is not grayed out, but it > simply does nothing with charts. > After your posting I tried it on my Vista/32 bit Notebook and my Win 7/32 > Netbook. It works on both. So it seems to be a Win/x64 issue. > > Thank you for your help. > > > > "Jon Peltier" <jonNO(a)SPAMpeltiertech.com> schrieb im Newsbeitrag > news:u0nvQ7iuKHA.5936(a)TK2MSFTNGP04.phx.gbl... >> Copy - Paste Special Format does in fact work with Excel 2007. What are >> the steps you are trying to follow? >> >> - Jon >> ------- >> Jon Peltier >> Peltier Technical Services, Inc. >> 774-275-0064 >> http://peltiertech.com/ >> >> >> On 3/1/2010 1:22 PM, Astelix wrote: >>> In older Versions of Excel it was possible to transfer the formatting >>> from one chart to another with copy/paste special formats. This doesn't >>> work in excel 2007. Excel 2007 has the option of saving chart templates >>> to multiply user defined formats. But this templates don't save many >>> formatting elements (colors, data label option etc.). This is extremly >>> annoying. >>> >>> Where can I find a documentation that lists all the Elements that are >>> saved in a cltx template? Is there any possibility to come close to the >>> old behavior? Is there anything changed in Excel 2010? >>> >>> TZS >>> >>>
From: Jon Peltier on 3 Mar 2010 23:10
Yes, pivot charts are "special", and sometimes follow their own rules. - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ On 3/3/2010 3:52 AM, Astelix wrote: > It is no 64 bit problem. > > Copy/Paste Special works with standard charts, but it doesn't work with > pivot charts (which I tried to use). User defined templates work > partially with pivot charts. > > "Astelix" <tzs(a)live.de> schrieb im Newsbeitrag > news:67D9347C-5E2E-4F4B-A48F-0BF822C873C6(a)microsoft.com... >> In my (German) Version (SP2 ) on Win 7/64 Paste Special (Inhalte >> einf�gen) doesn't. work. My boss also has Win 7/64 + Excel 2007 and it >> doesn't work either. The Item on the Ribbon is not grayed out, but it >> simply does nothing with charts. >> After your posting I tried it on my Vista/32 bit Notebook and my Win >> 7/32 Netbook. It works on both. So it seems to be a Win/x64 issue. >> >> Thank you for your help. >> >> >> >> "Jon Peltier" <jonNO(a)SPAMpeltiertech.com> schrieb im Newsbeitrag >> news:u0nvQ7iuKHA.5936(a)TK2MSFTNGP04.phx.gbl... >>> Copy - Paste Special Format does in fact work with Excel 2007. What >>> are the steps you are trying to follow? >>> >>> - Jon >>> ------- >>> Jon Peltier >>> Peltier Technical Services, Inc. >>> 774-275-0064 >>> http://peltiertech.com/ >>> >>> >>> On 3/1/2010 1:22 PM, Astelix wrote: >>>> In older Versions of Excel it was possible to transfer the formatting >>>> from one chart to another with copy/paste special formats. This doesn't >>>> work in excel 2007. Excel 2007 has the option of saving chart templates >>>> to multiply user defined formats. But this templates don't save many >>>> formatting elements (colors, data label option etc.). This is extremly >>>> annoying. >>>> >>>> Where can I find a documentation that lists all the Elements that are >>>> saved in a cltx template? Is there any possibility to come close to the >>>> old behavior? Is there anything changed in Excel 2010? >>>> >>>> TZS >>>> >>>> |