I need to have the days of the week show up on the X axis.
I have the days entered into the range, but they always
show up as dates, no matter how I try to format?
Thanks in advance

I have to regularly create charts in excel and want to automate this using a
macro/vba. The data to be plotted is: X-axis date & Y-axis: a number value
different for each date. The trouble is the number of these values (rows) is
different for each set. I therefore cannot keep my ...

Could anyone please help me?
I would like to set up a Stacked Column Chart of the following table.
       Gold medal Silver medal Bronze medal
       Day 1 Day 2 Day 1 Day 2 Day 1 Day 2

I have found it impossible to find out any information
regarding the calculation of area undernieth a specified
line in the 'area chart' option. How would you calculate a
given area undernieth a line?

In column A is a range of successive dates. In column B is
a formula that uses the associated date in A to return a
value from a set of data. The formula returns "" if the
associated date is greater than the maximum date in the

My pie chart has 10 data values (e.g. 10 sectors). The
legend shows a little box with the color that coordinates
with each sector and they are automatically numbered 1
thru 10.  

I can't seem to figure this one out or find it in my
books o if someone could assist I would be grateful.
I have 3 bars in my chart.  My fourth data point is a
bullet(line with bullet).  The bullet needs to appear in

Hi all, any idea on how to put color to your tabs (subsheets) ?
TIA
DANIEL

Does anyone know how to chart south and east coordinates
data with data as 3d vertical bars proportional to their
values?  If so please share with me.    
Thanks a bunch!!

I want to have a range of values for each data point -
example:
Item A I want the top of the bar to be at 115,000 and the
bottom at 85,000, Item B I want the top of the bar to be

I have a fixed start date and end date for the x axis
range - 9/18/2000 - 6/28/2003, and i have 10 dates that i
want to plot between these dates.  I want the x axis to
display only the fixed start and end dates.

I read thru some of the posts about plotting empty cells
and can't seem to find the right answer to my problem.  I
have a bar chart (Jan thru Dec) which I currently show
data running through June.  All cells contain the same

How do I emphasize one axis value by making that gridline
darker than the others:
example:
160,000__________________(gridline)

I have about 12 variables from which I would automatically
like to produce a pie chart each month.  However in any
one month at least 6 of these variables will be zero.  I
don't want these to be included on my pie chart or legend.

I am new to excel, never really  used it.
How do I draw a line if I now the  equation/formula.
let's say I want to plot/draw the line 2x + y = 20 (for all x>=0 and all
y>=0).