I am trying to set up a worksheet that allows the user to
input an interest rate and see what the various loan and
interest amounts would be.  How do I set up a data
validation where the interest rate cannot be greater than

I know that I have done this before, but I cannot remember
how....I have five series of data that I have stacked as a
stacked bar chart and I want the total to be shown as a
line on the top of the bars how do I do this.  For example:

I'm trying to modify a legend in a project that was
designed by someone else. Next to each colored box,
there's a label which I need to change. I've tried
everything I can think of, the last of which was

I am trying to find out if it is possible to set the minimum value on
the axis of a line graph to a variable on an excel spreadsheet (such
that it is a dynamic number, as opposed to when you input the starting
value of the axis which is static).

I've been working on this project for some time now, &
have resorted to a pie chart instead of the bars that is
preferred.  When I select the chart type, for ex. for 3D
all I get is narrow lines.  I have even downloaded the MS

I have a series of bar graphs (approximately 20 in total) and each one
is linked to a set of 5 data points (i.e. 5 point data scale). For
some of the points the value is zero and this is showing up
intermittently on my bar graphs - I want to get rid of the zero values

I need to change the color of legend icons from the
default purple and blues and such(which are btw all
horrible pastels) into custom color.  Is this possible
and if not then why not?

I am preparing an Excel line graph that must be quite
small to fit into the space available on a report.  
Everything works fine, except for the legend line which is
much too long.  If I drag the legend box sideways to be

Is it possible to apply custom text labels (sourced from spreadsheet column)
at various points of an x-y scatter chart?
Thanks
Graeme

Excel assigns a name to each new chart object on a
worksheet as they are created (Chart 1, Chart 2, ...).
If a chart is deleted the next chart created is assigned
the next sequential number, so if the last chart built

I am charting data that is based upon an "=if" conditional
statement.  However, when the condition is not met I want
a null value [i.e. if(A1=4,4,null)]  Since this doesn't
appear to work I am forced to use a space command [i.e. if

My first value is 0.  second is 1000.  third is...
I do not want the area chart between 0 and 1000 to ramp or
interpolate between the two values.  I want the area to
start only on the second value.  How can I do this?

I have data presented on rows as follows:
1   128655        Black, Robert    9:00 AM   Breakfast meeting at Holiday
2                                                              Inn.  Casual.
3   123456        Blow, Joe          4:30 PM   Customer wants to come

I need to change the color of a single grid line on a
chart. This is currently not allowed (at least I am not
able to). When you change color all the grid lines take
the same color. I need to change the color of a single

All excel gurus
I created a chart and when i'm trying to modify it by right click on
the chart Source Data option is grayed out not visible. Is any one
knows how resolve this issue.