How do I get my X axis and Y axis to auto scale inside my chart when I add
new data in my spreadsheet?

Does anyone know how I can delete some of the numbers on the x-axis? I have
numbers ranging from 9 to 55 but only want to show 9-21, 25-31, 41 and
finally 55. I cannot just delete them on the worksheet because they are used
in the formulas making the chart as (=1/(A9+1)*100) ...

Excel - 2003 or previous.
Conditional formating on cells is useful but I would like to see this on
graphs as well.
For example in a bar graph chart the series colour can be set either

I am trying to make a chart that tracks progress each week from Monday
to Friday.
i.e. June 5 to June 9, then June 12 - June 16.  This goes on the X-axis.
Each time I try and chart the series without the dates it works OK.  As

I am trying to put Data Labels on a Stock Chart, using a different data
source
for the chart and the labels (in adjacent columns)
I have tried various add-ins and trials (Jwalk chart tools and power pack,

I need to put identifying captions/labels below Excel charts.  I've used
something that I think was called captions in the past, but can't remember
how to do it.  These captions were outside the borders of the chart, but were
linked to the chart so when I moved the chart, the ...

I am trying to graph some information and can't figure out how to place a
solid column that references one number next to a stacked column that
references two numbers.  Maybe a better question is can I put two stacked
columns righ next to eachother?

My boss wants the legend inverted, instead of the 8% at the top, he'd like
the 12% at the top and the 8% at the bottom.  I switched the cells around
thinking that it would switch the legend data as well, no go.  Anyone have an
idea?

I'm trying to chart a bar graph to show the average responses of some survey data of two groups.
The bar values are 4.2 and 3.8
When I create the bar graph, the lowest value on the Y axis shows 3.5.  
How do I make the Y axis start at 0 to portray the entire scale?

I have a chart of values over time.  I have 5 data series taken from a data
table.  The values come up in the chart OK but as I wanted to format the
different data series for color and data point shape it only allows me to
format 4 series.  In fact when I right click the 5th data ...

Oh wise ones,
                   I have a range that is dynamically updated by a SQL
call. The data is changing every 2 seconds. The routine is populated by a
calulate sheet event. My range never changes, it is alway V4:V23 and the data

I have a chart that starts incrementing at 5,000.  Is there a way t
truncate  say between 0 - 25,000 (and perhaps show it as a broken ba
graph, like other graphing programs can do)?  If not, is there at leas
a way to make the increments larger?

I have a chart now with this in the data range:
=PHQChartQuery!$A$2:$C$7
But I would like it to look like this
=PHQChartQuery!$A$2:$C$500

How can I built a line graphic (one serie only) that as under the line a
coloured area without hiding the X and Y gridlines?

        Abr    Mai    Jun
Enc. Auto    58%    54%    #DIV/0!
Enc. Semi    30%    31%    #DIV/0!
Manuais    12%    15%    #DIV/0!