LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
DEE DEE is offline
external usenet poster
 
Posts: 250
Default How to control Bar colors for Pivot Chart

Hello, I created a Pivot Chart (3-D Clustered Bar), it works fine except when
I pivot the bars change colors, and the a white background appears on the
data points. How can I make it so that the bars keep their color and their
is no background in data on data points. Others will have to use this chart.
i'm open to using VBA.
--
DeeCee
 
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
can I bold or have different colors in a pivot table? marcy Excel Discussion (Misc queries) 1 October 13th 06 09:52 PM
pivot chart colors- how to keep from changing when data elements are added/removed? KR Charts and Charting in Excel 1 July 12th 06 06:41 PM
assign permanent colors to bars/values in a pivot chart Rose73 Charts and Charting in Excel 1 June 1st 06 05:59 PM
static colors in chart chart Johan Charts and Charting in Excel 1 September 22nd 05 01:01 PM
How do i stop the colors changing on my pivot chart when i refres. kev from uk Excel Discussion (Misc queries) 1 March 2nd 05 01:51 PM


All times are GMT +1. The time now is 09:01 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"