I've created a series of horizontal bar charts and all the text labels to the
left of the chart categories are centered.  I want them to be right-justified
so that the labels adjoin the chart bars.  The right justify button on the
tool bar can't be clicked.  Does anyone have any ...

I'm plotting data in a scatter plot.  The data values span -1 to ~16,000 and
I want them on the Y axis.  I do not want to plot the -1 values.  I've set
the Y axis scale minimum value to 0, but the -1 values are still displayed.  
I use the -1 values later in the chart, so ...

I have a chart that presents 2005, 2006, 2007 summary data as a column
chart and then 2007 by month as a line. To show the yearly data I have
a yearly category, after which I have individual months where the
yearly data is zero - sort of like a dummy series - because I only

I want to create a dynamic graph with dropdown selections for the varying
data series.  I tried:  Defined series names using the top cell of each
column, created a pull-down via a Data Validation List which chooses from the
top cell of each column of data, then created a chart ...

Hi MVPs,
I'm stuggleing with formatting an excel pivot table correctly in excel 2007.
Here is what i've got, a pivot table with hours as the values as compared to
the jobsites they are logged at.  here is my struggle.  I am trying to make

Sometimes Excel files get incredibly big very fast apparently without
adequate reason.  Once big one seems to never be able to get them smaller
again. Any ideas why and how to reduce?  What are the factors that one must
avoid if one needs small files? (My current file has jumped ...

I would like to change the default colors fot the lines and background in
Excel charts.  The default background is gray and wastes toner and the yellow
default color for series 2 data is difficult to see on a white backgound.  
Anyone know where these are stored or how to change ...

I am having a problem editing an excel template which I managed to cobble
together a while back.
The template is a dashboard report. It contains one specimen of a dashboard
for one store.

Trying to create a one page report with scatter chart and the data in table
form under the chart in portrait mode. Looks like Excel does not accept this
- has anyone found a work around for this?
Thanks in advance

Okay, I need some help.
I am using a Line Chart to plot 2 lines: one for cumulative budgeted amount
and the other for cumulative amount actually spent.
All of our expenses etc are recorded in a worksheet called "Expenses

Can Excel graph the following equation?  If so, how would I go about
doing this?
z=((.03y+.15)x+150.75)x
Basically, I have a different cost formula for each of 4 different

I have 3 columns, let's say A, B, C
Column A contains names (text information)
Column B contains numeric values
Column C contains numberic values

I have many entries of data in an Excel spreadsheet.  I add to it every day
and would like to create a chart.  Is there a way that my chart can update
every time I add a new entry?
Thank You

I am taking a science course and have to create a chart showing the slope and
then insert it into a word.doc.
No trouble creating the chart, but when i enter the =SLOPE(A2:A6,B2:B6)
I get the message: "reference not vald"

The analysis below (chart #1) shows what the IRR is at a 6.75% Cap Rate and a
$4.60 Rental Rate. The IRR was derived from a long formula of inputs (note
Cap Rate and Rental Rate were both one of the inputs). I need to create a
sensitivity (what if) analysis table showing what ...