First post for me on here.
I have some Excel charts, with least squares fit lines through the
data. On each chart I have a single extra data point (it's own series)
and I want to know the perpendicular distance from the line to this

Help! I want to chart results for the coming year where the data feeds
in month-by-month. The problem is that the chart pluges to zero for the
future months. How do I terminate the data at the current point (January
to September) without having to reset the data ranges every month?

Is there a way to show values in the legend - behind the series text?
Thanks, Phil

What would the cell formula be to make these x-axis labels?  I want only to
change the date in the first cell and have the next five dates be one week
later.  I presume it is an append (&) but can’t figure it out:
               Cell D4                             Cell E4         ...

I'm attempting to create colored vertical bands on a chart using directions
from peltiertech.  
http://www.peltiertech.com/Excel/Charts/ColoredVerticalBand.html
I can't get multiple bands (the last step at bottom of the webpage).  I end

After I've deleted data that I use in my pivot table/chart, how do I get rid
of the items that are still appearing in the drop down menus for each field?  
For example: I deleted a line because that person no longer work in this
company, but their ID still appears in the USER ID ...

how can you change the x-axe into a text x-as when the data are dates ?
on specific dates a want to show a specific value. When I want to
create e.g. a line-type chart, the values are ok, but the x-axe with
the dates becomes a time-ax in stead of showing the real dates from the

I am trying to format the individual labels on the category axis on an Excel
chart.  I want every other label in a different color and bold.  But the
entire category axis is formatted.  Does anyone have a suggestion?  The
category axis is years - 1990 through 2005.  I want the ...

How do I make a bar graph for class results? I tried and i came to step 2 of
4 and i dint not understand what i had to do at that part so if you could
please help me or respond before tomarrow thank you

Is there a chart type available that looks like a circular car speedometer
dial, with the values shown by concentric bars against a scale on the
circumference of the dial?
----------------

I'm creating a mail merge in Word, using a large Excel data source.  The
file contains multiple names, with various associated data.
I want to create an individualized chart for each name, using data
associated with their name in the Excel data source file.  One customized

I have an excel chart which is derived from  a pivot table. The pivot table
is updated on a weekly basis and I then print the chart. The values in the
Y-axis stay constant as well as the serie names.
The problem I'm having is that even if I change the legend color to be to my

after the super fast problem fixing last time i had a problem, i'd like
to ask the excel collective for some more help... :)
now trying to plot a combined bar chart and line graph.  I basically
want all the sets of data except one to appear as columns plotted

Sorry, I'm not really sure how to state this question succinctly. I
have data in an MSAccess Db re medications and the time\date and
amounts taken. Mads are entered only in the db on days when they are
taken yet I need the graph to show ALL days including days not taken.

I want to organize the charted results in decending order of longest bar to
shortest bar so a natural progression or trend can be seen easily.  Help!!