i plot line charts for the growth trends of top product brands..i want to
have the same color of the line for a particular brand in all the charts i
create...so i need a macro to have a fixed color for the series based on the
series name, so that i do not have to format each and ...

I have been asked to produce a simple column chart where one particular
column goes "off the scale", the idea being that this particular product is
so good compared to other similar products that it is "off the chart".
I have produced the chart and obtained the required result by ...

I want to create a line chart on access 2003 between the time line
based on a query. The query results are the number of incident each
day. So the query result looks something like this:
1/1/2006     5

How do I set up bar graph titles and headings along both axis?

Using Windows XP Pro and Excel 2003.  I have a simple line graph showing a
value as it changes over time.  I would like to show that there is an area
where the value should apear to be within tolerance.  I would like to show
this by placing a line at the minimum and maximum ...

Current Excel is able to create stacked column bars charts only on a single
value across categories, eg, X-axis - Jan, feb, etc, only one stacked bar.
Any advise if it is possible to create "stacked colums" comparing "valueS
across categories"? (Eg, X-axis - Jan will consite of a ...

In the legend box is there any way of making a legend key (the small coloured
box next to the item) bigger without increasing the size of the text?

I have a chart with the performance of certain stocks (x=date, y=value). I
add data to this chart weekly, and plot the year-to-date performance as well.
I would like to add grid lines at the start of each year: a vertical grid
line that is linked to a certain date and moves when ...

I have a stacked column chart with three colors on all three columns,
created automatically with code. When the column is small, the labels
come upon each other - can anybody tell how code can ensure that
datalabels come above eachother and not upon each other?

How do I make a line in an XY graph discontinious.  I have it working in one
place but not in another.  I cannot figure out what makes it work this way.  
It seems if you leave an empty X value has something to do with it.
Thanks

hi, we've got lots of data series we want to graph out in a line graph.  
value on Y axis, and time on x axis.  we want to link over 50 series to one
graph, then be able to check / un-check boxes so we can compare one line from
a series to another, and switch the series were ...

How do you change the "number of categories between tick-marks labels"
setting under Scale of Category (x) axis scale from code?
Thanks,
Clint

I would like to compare the areas under curves in a chart.
How to determine the area under a curve (integration) in Excel?

I used to be able to do this but now I can't seem to find the
functionality
I would like to plot multiple ranges (y-values) against a single range
(x-values)

How do I create a chart that has text values (freshman, sophomore, junior,
senior) instead of numbers (1, 2, 3, 4)?
I have a column labeled "What is your class standing?" and below it is 166
rows where people selected "Freshman," "Sophomore," etc.  I want to create a