Excel seems to have 2 alternatives for defining the min/ max value of an
axis: either automatically or preset by the user.
But is there any way that the minimum and maximum value that the axis is
defined by the user based on the values of the spreadsheet (i.e., halfway

I need to make a series of charts that depend on a column in my
datasheet. What I mean is this - I have data laid out per below, that
is logged by operators throughout the day:
Date     Time     Color     Reading

I'm trying to "square" a chart...
I mean:
given 2 points (P1 and P2) with coordinates
P1(x1,y1) and P2(x2,y2), I want set the vertical (y) distance between P2 and

I have a worksheet with about 8 charts on it. On all but 1 chart, when I
delete the Chart Title, the plot area expands. Can anyone tell me why this
happens? I'm no chart expert and I can't seem to find any obvious setting
that would control that behavior.

Using Excel 2003
I created one pie chart and then did a copy & paste to paste that same chart
into another worksheet.  Then I right-clicked and chose “Source Data” and
then highlighted the data for the new chart with the new raw data.  There’s

I am just learning to use Excel charts and need some assistance --
I want to show goals versus acutal on a horizontal bar chart  and i cannot
figure out how to format the data and label the axis.
Can you help me??

Has anyone else found an error in the trendline tool in excel 07?  I found
that when transforming the x axis to logarithmic, the trendline stays linear,
when it should curve with the axis.  I think this started happening when I
moved between 07 and 03 using the compatibility ...

Hi Folks - I have the following data:
Salaries        29%
Programs      71%
dept1            9%

http://peltiertech.com/Excel/Charts/statscharts.html
How can this dynamic control chart is made.  Need step by step instruction
Thanks
Daniel

Does anyone know how to create the notches in the vertical box whisker
charts?
An example can be found in figure 10 of the following article:
http://www.qualitydigest.com/oct97/html/excel.html

I'm using a stacked bar graph and would like to align the x axis label with
the edge of each column instead of having the label centered on each column.

I want to to create a chart where the colour changes when ever a value is
reached. Ex. I have a mashine that produces 1000 it's goal is 2000. The chart
should then show a column that is red because it is under the goal. I also
have a maschine that produces 3000 and the goal is ...

    I have a form I created in VB and it facilitates data entry into a
spreadsheet. Once I fill out the textboxes and click ok, it inserts a new row
into the spreadhseet with the new info below the second row. So all the other
rows containing previously entered info move down. I need ...

I am using the macro below to set the axis minimums, maximums, and major
units for a series of charts.  I would like to tie this macro to RefEdit
controls, so that when I enter the keyboard shortcut Ctrl+Shift+A in the
active chart, a dialog box opens with three RefEdit controls ...

I have data as follows:
       M     L    G    Y
Jan    5     7    8    2
Feb   4     7    1    4