When I create a pivot bar chart there are preset default colours.  I can
change the colours but when I refresh the data the colours change back to the
original ones.  How do I keep the same colours?

I created a chart on a worksheet and defined the X-ax (Category Xax
label =Position!$G$4:$G$42) and the first serie (Values
=Position!$O$4:$O$42). Everything looks OK.
Now I add another serie (Values =Position!$P$4:$P$42) and although this

I'm trying to create an x y scatter chart with 2 Y axis.  I follow the
instructions on the web site, but I don't get the option in the format
pull-down.  I'm beginning to think Excel 2000 doesn't support the 2 Y axis
option.  Am I nuts?

When I copy an Excel chart and paste it into a Word doc, the
red (negative) numbers print black.
How can I get them to stay red and print red as they
originally were in the Excel chart? Thanks in advance.

Several items here...
- In Excel, when one plots a chart containing a LOT of data with anything
other than a solid line, it is impossible to use any other format because the
line formatting restarts with EACH DATA POINT.  Let's say I have 5 plots I

I am trying to refresh a chart in an Excel 2000 worksheet without
recalculating the whole worksheet. Tried using the following syntax to no
avail (this is not a pivot chart):
ActiveSheet.ChartObjects("Chart 70").Select

Hello, I am trying to create a chart or graph that shows how many users are
concurrently logged into an application on our network. I would like to be
able to show this by day, week and month to indentify trends and high load
times. For the actual data I get a log file that shows ...

Hi, everybody,
I have just found this newsgroup and I wonder if anyone could help me with a
problem that has suddenly turned up:
I run Excel in an Office97 package on a Win98 system computer. I have a

I am using Microsoft office standard 2003. I wish to plot information on a
local area map within the Clapham Park area, SW2.

I would like to create a bar graph (in Excel or PP) that contains multiple
groups of information. For example, on one graph, a group of bars of "gender"
with bars of male and female, then a group of bars of "race" with bars of
black, white, Hispanic, then a group of bars of ...

Excel is inserting holidays and weekend days into my time series.  I want to
stop it doing this and to use only my date series.

I would like to add 2 values (value and percent) to my column bar chart.  I
need to see my raw N and the percent on one bar.  Anyone know how to do that?

How do I change z-axis value from zero to a higher number (eg 4)?
Am using a floating bac chart presenting open hours for help desk support.

I'm relatively new to excel macros and would greatly appreciate any
help.
In an Excel scatter chart, if I move the mouse over a data point,
a "tool-tip text" or a "hover text" appears.

I've a sheet with a cake pivot chart. I customized
different parts of the chart (colour of characters,
data format in perc.,etc). When I update the
pivot table connected, the chart loses my