I'm writing a macro in which the user has to choose 2 value on a bar-graph.
I can trap chart events as Jon Peltier say (
http://www.computorcompanion.com/LPMArticle.asp?ID=221, ), but following his
way I trap *always* chart events.

i want to produce a linear-log graph in excel (that means linear scale in
y-axis and log scale in x-axis)...however, the only form that i can draw a
graph is in log -linear graph (which is log scale in x-axis and linear scale
in y-axis).

How can I create a Statistic Process Control chart with 3 sigma Upper
control limit
and 3 sigma Lower control limit.  The chart must be updated with new data.
For example sale vs month chart for sale department and I know some data for

Here is my data:
Location           Flowers            Trees   
    Year 1    Year 2    Year 1    Year 2
Texas    55    63    36    14

In the same workbook I have several charts generated by pivot tables.
In one chart the data labels are at location "Outside end".
In the others under the "Label Position" "Outside end" does not show
as an option!

This is probably an easy question for most of you but I am not an avid Excel
user, or really a basic user at all.
What I have is data from a survey that I am trying to graph.  I have a
question1, an average response number, and a desired response number.  I need

I want to chart the following into a stacked bar chart
2007, Jan, Feb, Mar,
A, 3, 7, 4
B, 5, 10, 6

I'm trying to find some documentation to assist me in changing the
appearance of my charts so that they capture peoples attention when being
presented. I've tried the chart wizard but they're very flat and look like a
typical basic chart (no offense Microsoft).

Can someone help me figure out how to take two data points and have it appear
as a single entry in a Quadrant Chart.  EX: (X&Y-Axis are both on a scale of
1 to 10.  An entry may have X axis value of 6 and Y axis value of 8.  I would
like to have that represented as a single point ...

I am trying to fit a non-linear formula to a set of data in Excel 2007.  I
use the trendline feature and have selected several different formulas.  On
my chart, the trendline matches my data very well.
But, the formula that is displayed does not mathematically fit my data at

I am trying to learn how to do a pie chart.  I used the Chart Wizard, but not
getting the data I want.  I have a statistical page that gathers data from
another worksheet regarding paychecks.  Below is a general layout:
                         Payck1       Payck2       Payck3

I have rather simple bar charts comparing data for this year vs. last year.
On my monitor this year is colored black and last year a medium grey.
When I print the charts, the black prints as a medium grey and the medium
grey prints as white.

I am trying to change each individual bars color in a 3d bar chart in Excel
2003 based on the data points in the series. Can this even be done in Excel
2003?

I have created a population pyramid graph, which uses negative percentages
to show one side of the pyramid.
On my x-axis and on the data labels, I do not want to show these as negative
numbers.

I have the data set up similar to this:
             Group 1          Group 2          Group 3
A                1                 1.5                  0.8
B                5                 3.2                  2.5