I have a series of line charts (time-x vs value-y) with axis limits an
data ranges updated automatically.  I need to come up with a way t
identify certain periods of time with shading.  But I don't wish t
simply draw rectangles because I don't want to have to edit th

I have a column of several different names, most of which come up several
times.  I would like to make a graph of which names appear the most
frequently.  I haven't been able to figure out how to do this for the life of
me.

I am using Excel 2002, and I need to modify a chart so that it update
automatically. The way the spreadsheet is laid out is that it uses
row of months at the top, a bunch of detail rows below that, and tw
different total rows at the bottom. I'm only concerned with the month

I need help doing this.  I work for a music company and i have to enter
in sales once a week.  I'll try to explain it the best way i can.  And
will attach a picture to help.
When you get the picture opened; every week i type in numbers under

I am trying to make a chart that will pull the most recent 26 weeks of data
automatically so I won't have to go in and change the range every single
week.  I am adding the newest data to the right of the the existing data and
would like to have the chart just to the right of the ...

Whenever I select a Chart by default the colour of the 2 series are Blue &
Brown.    Is there any way by which I can change these colours to Red & Green
by default so that whenever I select data to create a chart the first series
should appear in Red bars and the next series ...

how do you make the x axis the dependent variable and the Y axis the
independent variable so that the curves progress up instead of across?

I would like to create a broken gap in the x axis of xy (scatter) chart in
order to reduce the portion of unused data in the chart along the x axis.
(Office 2000)

I have a spreadsheet with about 15 charts.  I want to be able to
automatically switch between charts in the "Main" tab based on an input.  So
for example if I input "1" chart #1 would appear in the "Main" tab.  All of
the charts are different (they have different units for the X ...

I have a basic bar chart, say from 1 to 100 percent. I want to be abl
to format the bars of this chart based on the Data Value.
Example>
I three bars, 100%, 25%, and 50%, I want the 100% bar to be the defaul

 Here is my question:
 I am adding a graph(line chart) as a new Excel-sheet, and wanting to
enlarge it's size.I think the ChartArea should be set like that:
   With ActiveChart.ChartArea

I am charting the passage of a low pressure system.
On the primary Y axis I am plotting Barometric Pressure as a line char
with values between 28 and 31 inches of mercury.
On the secondary Y axis I am plotting Wind Speed, Wind Gusts an

After a lot of search, I managed to do this:
Sub Macro1()
    minim = Range("param!i35").Value2
    maxim = Range("param!i45").Value2

Have a large address file on mailing labels . Have tried using Merge to
alphabetize the list, but find this rather cumbersome. Would like to find a
simple quick way to do it.  Any suggestions?

I'm a newbie to this forum.  I tried using the search function, but
could not get it to work for me.  Does anyone know if you can use a
connector to connect an arrow from a column to an offset point on a run
chart (when using a dual chart...Column and Line with two axes)?  I