Suppose I have a chart with, for example, data in it as follows (source data):
A1:A20
Every so often, I REWRITE over that same range new data...and create a new
chart!!

I am trying to create a chart that has an x-axis of temperatures that range
from-100 to 100 and a y-axis that shows altitiude fro 0-100.  I need the
chart to have one "wavy" line as its data points.  I am using excel 2007.  
Any suggestions?

How could you change the color of a line in a line chart so that at some
point on the graph the line changes color?
Say like the line chart shows data over the months of a year but at month
July, the line on the chart changes from blue to green and is green the rest

I am making a scatter chart (with lines) in Excel 2007 under
Vista. I can select a line style, for example, long dashes.
However, if I try to change the axis (change from "automatic" to
"fixed" on the horizontal axis), the line on the chart immediately

I am trying to create a chart with a X-axis that shows temperature from -100
to 100 and a Y-axis that shows altitude fro 0-100.  The data will create a
"wavy" line.  Any suggestions on the best chart to use and how to configure
the spreadsheet to create this would be greatly ...

I want a specific color for a chart I created, but the data series keeps
changing to a neon geen.  I've changed the color several times and it always
shows up neon green.  Any advice would be appreciated.
Thanks

Is there any way of display the system date, either within the title of the
chart, or anywhere else?
Cheers.
Bill.

Is there a magic quadrant template available

In Excel 2003, If you made a graph of a pivot table you would have buttons
inside the graph that would allow you to make certain selections or filters
inside the graph. Where are these in Excel 2007?
Can anybody help me?

I have data of the following format
X: year/month/day
Y: value
Y2: value2

I have data of the following format
X: year/month/day
Y: independent value
I want to highlight the area from Y to Y+0.5 for all X

I have an XY Scatter Chart with 100 entries.  The data points plotted fine,
but the graph automatically assigned a different symbol and color to each
data point.  To make the chart look cleaner, I wanted to make all of them the
same.  I can select and change the data points ...

I want to chart movements within a bank account.  So want to show
positive values with negatives offsetting to get to a bank balance.  I
want to do this with either bars or areas rather than lines.  For
example in one month I want to show £1000 income with £700 expenditure

I have created a macro to copy some graphs from 1 workbook to another
and formats them. However, after running the macro, it gives an error
saying "Run-time error '-2147417848 (80010108)': Automation error. The
object invoked has disconnected from its clients." This crashes excel

in the worksheet a graph has been made. it will not show the unless it is
clicked on otherwise it is just a grey box. how can i still see the graph and
edit the worksheet