pivotchart probs - losing graph colours and how to remove "place series fields here"

[neowok]

basically i have clicked on each bar in the pivotchart and manually
changed its colour to match the colour of the cells on my data table
where the original data is contained, and it keeps changing the damn
colour back to having every bar as plain blue, i think its doing this
every time it re-draws the table, which is basically every time you
load the workbook or change a cell on the data tables. there must be a
way to keep my colours on these bars somehow?

id also like to get rid of the "place series fields here" box which is
on he right of the chart, i cant seem to find any way to remove it.

 

[Debra Dalgleish]

The loss of formatting is a known problem. There's some info in the
following MSKB article, which suggests recording a macro as you apply
the formatting:

XL2000: Changing a PivotChart Removes Series Formatting
http://support.microsoft.com/?id=215904

You could incorporate that into your refresh code.

To remove the 'Place series fields here' box, from the Pivot toolbar
choose PivotChart>Hide PivotChart Field Buttons

 

[neowok]

heh that was excel 2000, im using 2002 (and 2003 at home) and still hav
the same problem.

yeah i tried the hide field buttons. the problem is this hides all th
field buttons and i need at least the page field button to stay ther
as this is 'date' and users will use it to view the chart by date. s
looks like i have to have them all on there

if theres nothing there then there should be a way of getting rid o
the unneeded box rather than having it sit there taking up space doin
absolutely nothing.

typical MS, takes 10 versions to get anything right. you would thin
these obvious, very common and very simple problems would have bee
fixed long before now (much like the 256 column limit i guess)

 

[Tom Ogilvy]

How about when a formula returns zero when it should return zero?