I have 1 named range created with the offset function on sheet(1):
Month=offset($A$1,0,0,counta($A:$A),1)
Simple to use as the x-as categories in a chart.
For the y-axis I want to use data which can be offset 1, 2, up to 20 columns.

Hi, All --
I've programmed a finite difference solution to the 2D Laplace equation in
Excel.  I plot the equipotential lines in a contour line chart.  So far, so
good.  The problem is that there is a grid underlying the contour lines.  

My boss asked me to make a bar graph and spreadsheet that will track
the sales of her employees.  She will input there sales at the end of
each day.
Each bar on the graph will be for a different employee and as the bar

Is there a way to eliminate some of the gridlines on a chart.  When I check
the gridlines I get a bunch across the chart.  I only want like 2 or three
vertical lines on the chart.

I work for an environmental engineering firm, and commonly create time-series
and other scatterplots of numerical data using Excel.
In Excel 2003, I could format a time-series scatterplot axis minimum and
maximum easily by typing in the dates in short date format. Not so in 2007 - ...

Area charts in Excel come up with a category axis for the X-axis, so that
points are evenly-spaced, regardless of value (the value is disregarded).  Is
there a way to create an area chart with a value axix for the X-axis, so that
points are spaced according to their values?  The ...

I am making a line graph for school.  But I need to extend the quadrants, and
extend the treadline back, how do I do this?

How can I change the color in a chart, so POSITIVE values is e.g. GREEN and
NEGATIVE VALUES is e.g. RED. This in the same chart?
Thanks!

Hi,
I have two sets of data and I am plotting both on the same chart.  I need
them to have separate y axes, because they have different ranges.  When I
select one data set and force it onto a secondary y-axis, it stops plotting

Does anybody know how to plot any equation within a excel chat? and also to
calculate the value of R or R2?
thanks alot.

How do you insert a new option button on existing charts?  Tried copy and
paste but this did not work.

Hello-
I am trying to do a graph of inventory levels by day. This is a simple line
graph. However, there is a target inventory level of 20-30 each day. What I
am trying to do is add some kind of color to the plot area only between the

I am attempting to chart the following:
Series 1 - Values over the prior 30 days
Series 2 - Values over the prior 12 months
I would like to show both data series as 100% bar charts, so users of

I want to learn how to set up a dashboard for my sales project. I just don't
know where to start. Charts and bitmaps....? Anybody?

I changed the name of a document which was connected as link to some charts
in another spreadsheet. Now the charts are blank becasue they are looking for
the spreadsheet with the name that does not exist anymore.  How do I change
the source data without going into each chart and ...