 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / February 2006pivotchart refreshing
I have a pivot chart with two axes one line and column. when i refresh my pivot where the chart is based on my chart does not retain it´s format. it changes to one axes. how do i prevent that happening ?. i tried autoformatting and preserve formatting but nothing helps lennie This is a known problem with pivot charts. There's some information in the following MSKB article, which suggests recording a macro as you apply the formatting: Changing a PivotChart removes series formatting in Excel http://support.microsoft.com/?id=215904 > I have a pivot chart with two axes one line and column. when i refresh > my pivot where the chart is based on my chart does not retain it´s > format. it changes to one axes. how do i prevent that happening ?. i > tried autoformatting and preserve formatting but nothing helps  SignatureDebra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.