I am attmepting to graph data that includes both numerical values and
non-numerical (i.e., "") values. The data is as follows:
             A                 B                     C               D      
  E

Is it possible to graph a logarithmic regression line on Excel? Here is the
line I need help graphing:::::1.649+1.968lnx
The Ln stand for natural log. Thanks!!

I created the scratter chart and I would like to have another line, showing
the average, will go horizontal across the scratter chart.
Ex: 4,5,6,7,10 are data to create a scratter chart.
The averager of 4,5,6,7,10 is 6.4

Here is what I would like to do; I’d like to shade the area following the
crossing of Line1 and Line2 in a different color and highlight and label the
point at which the lines cross.  Line1 is “Current Cost” and Line2 is
“Projected Cost”, the area following the crossing I’d like ...

Bit of a strange one this.  I have a workbook containing lots of charts
built using dynamic ranges.  I have built them in XL2000, where all is
well, but on opening in XL97 via a Citrix W2000 Desktop, the x-labels
disappear.  I have tried all the following to get them to reappear:

There is adiagram with values of a stock
And there are values before 2003 and after 2003
There is possibility in the plot area the colour to be double?
For example in the area of values befor 2003 to be yellow and after 2003 to

I thought this would be easy, but I am really stumped!
I need to show the percentage in addition to the value in the data labels
for a line chart.
Example,

Microsoft Office Excel 2003 (11.6355.6360) SP1
When you record a macro in Excel to produce a Pie Chart with 'Chart Title',
'Category Name' and 'Percentage', and when the macro is run it produces the
Chart with 'Chart Title' but does NOT add the 'Category Name' and

I sent a questionnaire out to 700 employees, 200 of which completed and
returned them.  I am now trying to produce the results in a 'pie of pie'
chart - the one with two pies.
I want the first chart to show that 700 questionnaires were sent out and 200

Can someone tell me how to create the following style of chart?
[image: http://img427.imageshack.us/img427/5287/examplechart6cr.png]
Thanks. :)

When automating Excel, if there is a picture (graphic) on the worksheet, when
the file is opened, the picture has the focus and mouse-clicks anywhere on
the Excel window are lost.  Is there a way to get the focus back so that
other cells can be editted?

I've learned about dynamic charts in this forum which has been very helpful
in autmating some charts that I use.  I would also like the chart title be
linked in some way to a cell.  Is that possible?

I am trying to draw a graph here, plotted graph x, with function f(x) at
y-axis, does anyone know how to get the approximation to the root of f(x) in
this interval. What is the value of x if i wish to obtain f(x)=0?

I need 2 stacked columns side by side for each month.
Here is the data for October:
Forecast Credits    200
Forecast Cash        50

Hope someone can help. I have a chart i want to make look a little more
professional.
The chart plots three points within two boxes. the points should be
inside the box