Hi All.......
I was given an Excel file that for some reason, every once in a while pops
up this message.........
"The maximum number of data points you can use in a data series for a 2-D

I have a scatter plot with a linear trendline.  What I would like to
be able to chart is a different background color that's separated by
the trendline.  So a different background color for anything above the
trendline and a different color below the trendline.

Is it possible to have data labels as a percentage on a pivotchart ?

I want to make the size of the box in an organization chart to automatically
fit around the text in it.  The selection for automatic size under alignment
in the Format AutoShape menu is not accessible.  It's there, but I can't
click on it.

Is there a way to do conditional formatting in a data table in charting?  For
example,
 I want to highlight any negative values,  but not the positive.    Can
those same volumes also be highlighted or differentiated in some way on the

I have spreadsheets with a lot of data in them.  I have multiple columns.  
The two columns I need to compare right now have initials in one column and
dates in another column.  The initials are nurses and the date column is a
denial date.  I need to create a chart that will show ...

I am trying to create a pie chart using the chart wizard.  I want it to
present the data in cell A1 and A2 which together make up 100%.  Cell A1 is
6.6% which represents Less than 24 and Cell A2 is 93.4% which represents
Greater than 24.  I am stuck on Step 2 of 4 – Chart Source ...

Previous versions of Excel I was able to copy the sheets with charts to
separate file and then save. This works in 2007 however intermittently it
will change the horizontal axis and reduce the amount of data that is
presented in the chart. I've not been able to determine how to ...

Hi,  I'm a research scientist and excel spreadsheets are part of our
livelihood.  I could not find a way to change the format of a data point on
my bargraph with crosshatching, which patterns were available on the older
versions.  There are a preset of texture options, but little ...

is there a way to plot different colors for individual points on a
scatterplot with only 1 series?
my data looks like this
x    y    time

A Standard Distribution chart needs to have 2 catagory axes which show (i)
the X values and (ii) the normalised X values. Or rather it would be nice to
do this.
Any ideas out there?

What am I missing? I want to chart the data below using a pie chart with a
legend that tells me what each of the pieces of the pie represents. I tried
selecting cells A1 and A2  and I have tried selecting cells A1:B2. All I end
up with is a legend with the 2 colors represented on ...

I have a shape that I have created.  The problem is that this shape
covers my scatter plot.  Is there a way I could have the data points
be on top of the shape so I can click on the points?  I know you can
make the shape transparent but I would like to be able to interact

I have a scatter chart with 6 different series, one for each day of the week
( minus sunday) each one list the amount of customers help in my shop on each
individual day. However after the 11 day, it seems I can not add anymore
dates.

I am trying to plot a graph with the time on the y-axis and days on the
x-axis..
The chart is suppose to plot the trends of when a process is completed -
this process includes 4 specific items. There are 4 daily tasks that are to