Using Excel 2007, evertyime I refresh pivot table data, my charts lose almost
all of the formatting (ex. axis will disappear and chart type will revert
from lines to columns).
Most annoying problem I have when this happens is the primary Y axis moves

Using Excel 2007. Is it possible to change the appearance of a line in a
chart for values in the future (like projections)? I would like to go from
solid to dashed and keep the same color and weight.

I was wondering if Excel will allow a series name to be dynamic?
For example, ="30-Day Target, (" +  sheetname!cell + ")"
where sheetname!.cell value is a date
to yield a Series Name = 30-Day Target, (mm.dd.yyyy)

I'm creating a chart which has a nonzero starting point for both axes and
need to insert the appropriate hash-mark which indicates that the axis does
not start at zero.  I'm unable to find this option in excel.  Any help or
suggestions would truly be appreciated.  Thanks!

I have a chart of net income for a fiscal year and there are several months
that stand out and I would like to put an explaination on the chart either
with notes at the bottom or a note at the top of the bar that I want to
explain....is that possible?

I am a student trying to learn/understand excel on my own, this is my question:
In a chart if I selected cells B5:B10, as my data series for a chart, and
specified the data series are in columns. What will be my legend text?
Cells B5:B10,  Cells C6:F10,  B5:B10, or impossible to ...

I have a bar chart for resource analysis and I want to add a % to the chart.  
I calculate it in a cell.  Is there anyway to add a textbox and put the value
of a cell in it?

I have a simple columns chart with two series stacked on top of each other.
(different colors with values inside)
I would like to add a third series in form if a line which would be the
total of the two values

I am pulling my hair out over this stupid thing.  I am using MS Excel 2003
I have a column of data that I am trying to graph the problem is the column
derives its data from a formula in the cell if the formula is true than the
cell has a visible data value in it if it is false the ...

I have an interesting question on charting, hope someone can help me
out with it. For a performance analysis I am showing both the
performance of a portfolio (line) and its corresponding benchmark
(bar). In order to make the out- or under performance more visible I

I am using excel 2007. I am trying to create a chart with 20 weeks in
the x axis. The chart type is Column, clustered column. The chart
displays two lots of data.
The problem is, the columns are displayed as very thin, in fact

I am using trendline feature in charting to develop a third order polynomial
equation. The fit is good and I want to use the displayed equation to
calculate nondata point values.
I cannot get the equation to generate points within the original data set.

Other than adding a text box, is there a way to add text in each column
individually?
Example:  I have a chart showing several tasks and the their cost is listed
as a data label (aligned: outsided end).  I'd like to add the hours it takes

Is this possible anyhow?
I am using the chart to accuratley draw a grid in an xy scatter char
and have used my allowed 255 data series.
I need another 100 or so. Can it be done??

I'd like to add data labels to some of the data points on a line chart.
I know how to do it manually, but I'd like to do it in a way that
permanently associates the data label with the data point in the underlying
data series.