I remember vaguely seeing something like this being
discussed here, but I no longer recall the details.
What I'm trying to graph from worksheet data is a price
continuum chart, which is essentially a single graduated

I originally posted this in microsoft.pulic.excel but was advised to post
here as well - so please don't yell at me about posting to multiple groups

***

After I create a bar chart. I need to be able to click on
any bar and drill down on the data for that bar.
How do I identify using macros which bar was click so that
I can show the relevant data?

Since upgrading to Office 2003, I am unable to
successfully paste Graphs made in Excel as enhanced
metafiles into my office's Microsoft Word report template.
When I paste special, as an enhanced metafile, I am only

I am trying to create a scatter plot in excel based on the
following data set.
X-Axis: 1    2    3    4    5    6    7
    8    9    10    11    12    13    14

I am trying to change the size and shape of the boxes in a legend.  By
default, they are small squares but I have seen graphs where they are
rectangular which makes it easier to identify the colour.

I have a burndown graph, so the trendline has a negative slope.
I'm only interested in the X-intercept.
How do I keep the trendline from exceeding the normal bounds of the chart?
When it goes down to -2000, it shrinks the rest of the chart

I'm trying to make an XY scatter chart which my users will be able to
change, just by changing the data in the data ranges.
The chart contains several curves each having its own legend/text box,
placed at the right end point of the curve.

Is there some way or an add-in in Excel 2000 to create a
scatter dot-plot (X axis=categories, Y axis= numbers)
where dots with the same Y value would not overlap (by
moving overlapped dots along the X axis within each

I am looking to see if the following is possible?
I have 20 departments with 4 regional managers looking after them.
I have created 4 separate bar charts (laid sideways) on one excel shee
for each regional manager showing his departments figures. This work

Hi there.  Am a new member here and I wish to find out about some way
of charting these evaluation that I have.
For example, I have this table:
W(10%)        X(10%)        Y(10%)        Z(5%)      Total Score(35%)

I want to enter a number into a cell and this number will automatically add
its value into another cell.  However, after the pressing the enter key, I
want the entered number to be disappeared, leaving room for the next number.
How can I accomplish this?  Or is this possible?

How do you import dates from one spead sheet to another?
The cells are in different locations but have the same
names. on the left is ID and on the top would be the
deliverable good. Between would be the actual date

I'm making a chart that is for a physics class, heres the problem. I graph
volume vs. radius and it works fine. so i then calculate radius squared and
graph volume and r^2 but it show a weird line then in the first tab of
information (using x-y scatter chart) is say below that ...

Does anyone how to make a step chart with Excel?
BR
KaaDee