Hello;
I have searched the help files, several programming in excel books and this
forum to try to discover how to convert a Range object into it's constituent
double values in order to use Ln(...) in module.. eg

Firstly apologies if I have allready posted this but I experienced
problems just after hitting post and now cannot locate my message in
the group.
Anyway my question is this...

I'm a civil/struct. design engineer.
I use Excel's Drawing Tools (View-Toolbars-Drawing) to illustrate the
calculations and make sketches. I'm convinced that making sketches
with calc's is very important. When I first started making sketches it

Is there any way to create a side by side bar chart with
one bar being a stacked bar?  Here's the data:
Name          Q2   Q3wk1    Q3wk2     Q3wk3
Ann           86    9    6    11

My problem is the following:
I have a big matix of data with the folowing structure:
        Jan Feb Mar ...
data1    ... ... ... ...

I've checked to show values and labels.  The zero value
shows with no label. In some cases I have 3 or 4 zero
values, so I get a nice pie chart with a bunch of 0%
labels. Is there an option to supress showing the value

I used the OFFSET Function in Excel to create a dynamic
range i.e. the range size changes. I checked the dynamic
nature of the range being created by the OFFSET function
and it works well.

I have a chart in which the majority of the values are in
the range 0-10, but a couple are around 100. (The chart
might be a bar chart or line graph depending on the end
users' eventual preference.)

I have generated a lot of charts, which resides inside an
MS EXCEL file. These charts are updated regularly and I am
required to present the results to management.
Questions:

Any help with this will be greatly appreciated. I'm using excel 97. I
want to create a map of the US showing business trips. For instance, say
I live in Seattle and want to show trips to New York, Dallas and San
Francisco. On the map I would like to have lines run from Seattle to

Does anybody know of a method for generating waterfall plots using Excel?
I am wanting to produce a graph to plot temperature against engine speed and torque.
Thanks in advance for any help,
Andy

Hi there!  I have a user that creates lots of bar charts
and is spending countless hours trying to get his text
boxes with arrows to print properly.  I have looked at
his files and they look great on the screen, however,

I'm trying to copy, as pictures, a considerable number of charts from
different sheets onto a consolidated sheet that I can then distribute
without the large quantity of underlying data and calculations.  All the
charts were generated by the same VBA routine and each includes three ...

I need help with the stock graph. I am making a graph that uses high,
low, and middle value as the stock chart does. But I need the value
axis to be on the bottom were the x axis is and the category axis to be
the Y axis. I want the final chart to have the high, low and middle

I am trying to create a radar chart with varying x-axis
around the chart. How do I do this?