I need to make a trendline for one series, however, I want a trend fo
say Jan-June and a separate trendline for July-Dec.  short of placin
each data set on a separate line in the worksheet, how do I do this?
Thank

I need to create an expense sheet in excel that has the same 'title' (e.g.,
"transportation", "business lunch", "advertising" read down the left
side/columns, and "date", "cost", "vendor" read across the top/rows)
information in column A (for example) on each page, for what will ...

Please can anyone help me with a couple of questions I have about am Excel XP
spreadsheet I have devised to pass out to other people.
1. I have a graphic on the spreadsheet which I want to make 'delete proof' I
have used cell protection and a pass work to protect the sheet, but ...

Every time I try to create a chart it causes XL to crash.  I use the Chart
Wizard, set up the parameters for the chart, select Finish, and then XL
shuts down and restarts.  I have tried various types of charts with the same
results.  I have rebooted, but get the same results.

I am having a problem while adding more than one vertical line to one of my
graphs. This is because the data I am tracking is on a monthly basis, while
the tutorial(link:
http://peltiertech.com/Excel/Charts/AddLineVertSeries.html)  explains how to

I need to make a couple of graphs to show an audio signal bein
digitilised. So i need to show quantization using square data markers
but these need to have a vertical line going up to them from the
axis.

I've seen a lot about conditional format on chart points, but I'm looking to
turn legend text one of 3 colors depending on a cell value.  I am creating a
stoplight type of chart where if a value (column n is <x the category title
in column l is red; if n is between y and z then ...

Not sure if this is an issue on our LAN or if this is an Excel 98 bug -
I have got some spreadsheets that after I update the source data for
charts (on manual calculation) the actual chart will not reflect the
change.  If I select the series and hit enter on the formula bar, the

I have a line graph with values for years. Between the years 1998 and 1999
there was a coding change so I don't want the line to connect the points for
those two years. I have selected the second point, right clicked and selected
format data point. In the dialog box under the ...

Hy,
Do you know if it is possible to have secondary graduation with a
logarithm scale ? I have a graph with scale 1 to 10. I can obtain the
main lines and the secondary lines but only the main number.

Hi.  I am trying to figure out how to implement phase changes in an
Excel chart trend line.  This is possible on the charting here:
http://www.interventioncentral.org/htmdocs/tools/chartdog/chartdog.shtml
To explain, this would allow me to indicate a place on the x axis

When using the "surface" charts, Excel draws the surface and overlays a
squared grid on the surface.
I don't mean the walls grids which are drawn on the side walls of the chart,
but the grid drawn on the chart itself.

I have a number of charts created, but for them to provide accurate
information, i need to adjust the width of the individual columns based on
perentages to obtain an accurate median figure.

I have a problem with a stacked chart in excel 2000, i have used th
search function but could not find a solution.
The problem is as follows:
I want to create a chart with one stacked bar (consisting of

Hi! I have this chart in Excel, and sometimes when I change its proportions
the legend with all the headings automatically change into a two column
thing, which I like. The problem is that it also automatically changes back
into a one column thing whenever I increase the font ...