I would like to plot a graph (its a stress vs strain curve) based on the
following values:
y axis       x axis
0.00    0

If I have a set of data, is there any way I can generate a formula which
roughly matches the plot of the data set? I know I can generate a trend line
on a chart but is there a way of finding out the formula for this trendline,
so that I could reproduce it without the origiinal ...

I have a program that automatically sets the segments in a pie chart t
the correct colour (set using RGB(c1,c2,c3)) see code below
Charts("EPE Wheel").SeriesCollection(1).Points(pnt).Interior.Color
RGB(c1, c2, c3)

I have 5 sets of data about 5 subjects (people) that I want to put into 1
chart. The dats sets are unrelated to each other & have different scales. I
am an Excel novice.Is it possible to plot the data on a circle divided into 5
sections for the subjects with each subject section ...

I am looking for a funnel chart for excel as opposed to making just a crude
drawing with lines.

Does anybody know how can I replace part of the reference with the value
from the cell? For instance, in the reference to another workbook
='[OP 26 ST 42.xls]Sheet1'!$D$6
that references to the cell D6 in Sheet1 in workbook OP 26 ST 42.xls i want

Hope I'm posting in the correct forum.  I'm trying to create a pareto chart
(column and line) using Pivot Tables and I've got it 2/3 done.  I'm stuck on
the last part, and am hoping someone can help me or tell me whether or not
it's even possible.

I need to have a bar graph with two data sets of different scales, yet when I
change one data set to an secondary axis, the two bars combine.  I need them
to be sitting side by side.
thanks

I have a custom chart template that I use.  I want to share it with a
coworker.  How do I "export" it or copy it to their machine?
TIA

I am get an "Unable to read file" error message when opening a Excel
file that contains a PivotTable report.
All the symptoms match microsoft support article 819853, except I am
using Office 2003 not 2002.

I am trying to use VBA to dynamically produce a number of charts. Th
number of charts produced depends on the amount of data that appears i
a seperate spreadsheet...
I have taken the code produced when I recorded a macro to produce on

I am trying to set up dynamic charts for multiple data arrays, but the OFFSET
function will not return more than one reference.  If height or width is not
1, I get a #VALUE error.  Has anyone had success from "Using named ranges to
create dynamic charts in Excel" in the excel ...

On my spreadsheet, I've got three columns (compass bearing from a smoke
stack, distance from the stack, and smoke concentrations downwind from our
stack).  Can Excel create a 2-D (concentration value shown at distance and
bearing) or 3-D plot (this might look like a topo map on a ...

Whenever you create a line chart using excel 2000. The smoothline option is
selected by default. How do I disable this? I want all my users to create a
charts without smoothline.
Regards,

Hi to all,
I pasted together the below attachment.
Can anyone help me with it. I need to know how to start a second grap
55% of the way up the original graphs axis.