Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Johan
 
Posts: n/a
Default static colors in chart chart

I have an excel chart which is derived from a pivot table. The pivot table
is updated on a weekly basis and I then print the chart. The values in the
Y-axis stay constant as well as the serie names.
The problem I'm having is that even if I change the legend color to be to my
liking, when-ever I update the pivot table the chart automatically re-applies
it's own color codes to the legend.
Is there any way around this?
  #2   Report Post  
bj
 
Posts: n/a
Default

a common way to handle this issue is to set up a sheet to print your graph
from and copy the data in the pivot table and paste onto the new sheet. Then
generate your custom chart.
When the pivot table is updated. copy the pivot table and paste over the
data in the grph prep sheet.

In other words, people have hade this issue for a long time.

A macro can be used to do the copy paste or a macro could be used to
reformat the pivot table chart

"Johan" wrote:

I have an excel chart which is derived from a pivot table. The pivot table
is updated on a weekly basis and I then print the chart. The values in the
Y-axis stay constant as well as the serie names.
The problem I'm having is that even if I change the legend color to be to my
liking, when-ever I update the pivot table the chart automatically re-applies
it's own color codes to the legend.
Is there any way around this?

Reply
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
Activating a Chart object Hari Prasadh Charts and Charting in Excel 6 August 2nd 05 07:22 PM
chart default colors wendyeyes Charts and Charting in Excel 1 July 30th 05 04:21 PM
Urgent Chart Assistance Brent E Charts and Charting in Excel 1 May 10th 05 09:09 AM
Urgent Chart Questions Brent E Excel Discussion (Misc queries) 0 May 9th 05 11:01 PM
Urgent Chart Assistance Requested Brent E Excel Discussion (Misc queries) 0 May 9th 05 11:01 PM


All times are GMT +1. The time now is 11:53 PM.

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

About Us

"It's about Microsoft Excel"