I was trying to include the value of each bar in a bar
chart. But the alignment menu for the data label only
allows for inside top, middle and end, which overlaps with
the bar and make it difficult to read. How do I make these

Is there any way I can get Excel to figure out the area under the line in my graph for volume calculations?  What about on an area graph?

Is anyone aware of a way of linking chart parameters
normally set in the various dialog boxes, to a value in a
cell.  For example, suppose I'd like the value (Y) axis
minimum and maximum value to change based on the value of

Here is my goal... I would like to be able to select a pull down with
sorta lookup of e.g A, B, C, etc. program which reside on differen
tabs and be able to select program A and the chart shows stats for A
Next go to pull down and select B to see B's stats and so on. All whic

Hi, I want to draw a chart which contains two series. One is monthl
data and the other is quarterly. Is there a way of combining them
-----------------------------------------------
~~

How can I use Excel to find teh gradient at any point of a cumulativ
frequency curve
-----------------------------------------------
~~

I need to make a variable width 100% stacked column chart (similar t
the Column chart with varying width bars from andypope.info but 100
stacked)
The x-axis would contain various market segments and the width would b

Is there code I can put in a worksheet code page that will
tab only certain cells, and not allow the user to select
any other cell?  Unprotected cells are the targets here.
Thanks, Phil

------------------------------------------------------------------------
A poll associated with this post was created, to vote and see the
results, please visit http://www.excelforum.com/showthread.php?threadid=169056

I have a waterfall chart showing:
Budget 20xx
Variance type 1
Variance type 2

I have the code that connects to external data and created tabl
summary in excel. On the next sheet I created pivot table chart whic
also nicely shows important data.
Unfortunately after table update the format is lost and replaced wit

I have two separate plots on one chart. A set of points (blobs) and
separate fitted line. However the line is 'engulfed' by the points.
have tried 'series order' - but it doesn't stop the points appearing o
top of the line

I am using VBA code in Access to send revenue figures per month for th
year to Excel there is a chart which shows this information already i
Excel which just updates when the new information is sent. There i
also calculated fields in Excel which calculate the revenue by quarte

I am in need of changing the Axes Scale on my spreadsheet
from 0 to 500 to 100 to 900 but in 100 increments.  I
tried to format the Axis this way but then my data on the
chart disappears.  When I check the boxes back to

I would like be able to start a VBA-Procedure, when
the mouse pointer hovers over a certain data point in
a chart (XL 2003).
Obviously, XL knows when the cursor "touches" a data