How do you assign the Excel file name automatically in the chart of the file.
We are developing a templete file. Each file has 5-10 charts and we would
like to have the chart title to include the file name.
We are familiar with the header code "&[file]" but it does not work in the

Hi
I am trying to plot a normal distribution curve using vba. i think there is
a way to use loops to generate the x and hence y values.
I understand that we use

I am trying to create an area chart but I know I'm doing something wrong.
What I want is a chart that will plot the intersection of two numbers and
show a label (happens to be a date).
Both axis go for zero to 1. I have a query table that shows:

We have name of projects with 8 different status.  We want to create a chart
with the name of the project on the X axis and text status on the Y axis.  
Can this be done and if so how.  Please help
DDBeards

Dear All  :)
I understand in an excel 3d graph the x axis is a category axis, the
axis
is a series axis and the z axis is a numerical axis.

I am trying to plot a scatter plot where I would like each point to have a
specific name.  For instance, I have three columns, company name, total
revenue, and % margin.  I would like to plot revenu vs. % margin and when
clicking on a specific point, I would like to find out the ...

I would like to analyze data that, if put together on the same chart, one
would be flattened by the size of the other. I am already using bothh axis.
It's kind of like I need a third and fourth axis.

I have a chart that has a Y axis on the left and on the right side of the
chart. Is there any way to have 2 Y axes on the left and 2 on the right? I
would like to be able to compare 4 sets of data at the same time and the
range of values might be much different.

I am moving data from Access to Excel Sheets. Once the data is in Excel, I
need to create Pivot table for the same and on the basis of Pivot table,
charts need to be generated.
I did created Pivot table and its related charts, but I am having problem in

Thanks for this Jon.......
I found it doing a Google Search.....used it 21 times today.  It works super.
Vaya con Dios,
Chuck, CABGx3

Is there a way to fit a curve to a fuction such as
y= A+B*sin((2*PI*x/D) +C)^(-e*x) + F*x
in Excel, or is this too difficult to do in Excel?

How do I exclude the last three rows of a graph that is automatically
refreshed?  

Is there a way that I can plot two functions into one chart?  I mean that I
only need write the first function (eg. Y = 3*x^2) in Cell A1 and the second
function (eg. Y = exp(x) +x) in Cell A2 and get both functions plotted in the
same chart.

I have two charts that are the same size and I want to print them separately
and compare data by physically laying one above the other on a table.
The x axis on one has dates, i.e.
Oct. 1   Oct. 2    Oct. 3      etc

This may be a tough one... I have found no resource yet to assist with
creating my report in Excel.
I am trying to create a barchart report in Excel that depicts the
following: