LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Arlen
 
Posts: n/a
Default Pivot chart Refresh wrecks HAVOC!

When I'm using a pivot chart graph to track stuff, any time I update the
spreadsheet and refresh the Pivot Graph, all the labels go back to default.
I like them Above the data point, and Aligned at 45 degrees, for maximum
readability. How do I keep it this way even when I hit that Refresh button?

Also, how do you use Pivot Table fields that are not contiguous? In other
words, I have Dates in Column A, which I want to use with data in Column C,
D, H and so forth, without copying Column A and putting it next to each of
these other columns.

Thanks, everybody.

Arlen
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
pivot chart formatting Renato Charts and Charting in Excel 1 January 19th 05 01:19 PM
Pivot Chart: cannot apply the default chart type... doco Charts and Charting in Excel 1 January 17th 05 04:55 PM
pivot chart format Valeria Charts and Charting in Excel 1 January 14th 05 01:19 PM
pivot table multi line chart souris Charts and Charting in Excel 2 December 7th 04 03:56 AM
using the PIVOT TABLE and CHART Big Red Excel Discussion (Misc queries) 1 November 29th 04 08:42 PM


All times are GMT +1. The time now is 11:18 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"